Tag: ALL Function

Highlight The Last Or Current Period In Your Power BI Visuals Using DAX

Highlight The Last Or Current Period In Your Power BI Visuals Using DAX

Conditional formatting is a way of visualizing data by applying a certain set of format rules based on user-defined conditions. For Power BI visuals, it is mostly used when presenting data in a tabular form. In this tutorial, I’ll discuss how to combine DAX formulas with the new conditional formatting feature to highlight the last

Continue reading

A Deep Dive Into How The ALLSELECTED DAX Function Is Used In Power BI

The ALLSELECTED DAX function inside Power BI is one of the more advanced functions that you can utilize within your reports and dashboards. ALLSELECTED DAX function is a derivative of the ALL functions. So there’s ALL, ALLSELECTED and ALLEXCEPT. They all do something similar, which is remove the context or filters. Here, we’ll focus on

Continue reading

Using The ALL Function In Power BI For High Quality Insights

This blog post will show you how to use the ALL function in Power BI to effectively showcase unique insights and differentials in your numbers. We’re going to dive into the average order size for the sales we may be making across a variety of different products. This tutorial will also show you how to

Continue reading

ALL Function in Power BI – How To Use It With DAX

Did you know that the ALL function can be used to modify the context of a particular calculation in Power BI? Find out everything about how this function works in the post below. What Is The ALL Function In Power BI? The ALL function is an extremely important part of the DAX language in Power

Continue reading

Calculating % of Totals

A really common calculation that we require quite often is to calculate the % of a total amount. This is great to quickly show where the larger portion of results sit versus the entire population. Completing this in Power BI does not require much written code, but it does require some understanding. It will generally be

Continue reading