From the course: Power BI Weekly

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Calculation groups with the DAX SELECTEDMEASURE function

Calculation groups with the DAX SELECTEDMEASURE function - Power BI Tutorial

From the course: Power BI Weekly

Start my 1-month free trial Buy for my team

Calculation groups with the DAX SELECTEDMEASURE function

“

- [Jennifer] Let's say that we want to calculate a series of DAX measures in our Power BI model using repeatable logic. For example, let's say we're looking to calculate sales, costs, payments, and receivables, and we're looking to calculate all these time intelligence numbers on a month-to-date, quarter-to-date, year-to-date, and rolling average basis to give us a total of 16 measures. Using calculation groups, we can set this up by creating just four base DAX measures. We then create four calculation groups that will apply to each one of these measures. We can think of calculation groups as wrappers that go around DAX measures to apply the same summarization to all of them. We configure calculation groups with the help of the selected measured DAX function, which evaluates DAX measures in the context of the calculation group. Calculation groups can seem confusing at first, so let's try them out with a few different examples. In Power BI Desktop, I already set up the measures in a…

Contents