Calculation groups possibility to improve performance

[AnthonyJoseph]

Hi Champs,

My dashboard report page has two overview boxes (one for the selected year and another for prior year) for different category values (such as Sales, Revenue, Profit, and Margin).

Right now, we are using two measures for calculating each of the category values as mentioned below:

Sales = sum(Data[sales])
Revenue = sum(Data[revenue])
Profit = sum(Data[profit])
Selected year = Year[Year]  //Disconnected table to "Data" table

Selected year sales = Calculate(Sales,Data[Year] = Selected year)
Prior year sales = Calculate(Sales,Data[Year] = Selected year - 1)

Selected year revenue = Calculate(Revenue,Data[Year] = Selected year)
Prior year revenue = Calculate(Revenue,Data[Year] = Selected year - 1)

Selected year Profit = Calculate(Profit,Data[Year] = Selected year)
Prior year Profit = Calculate(Profit,Data[Year] = Selected year - 1)

Now, the request is to reduce the number of measures. As the number of categories are increasing, would using calculation groups be a better option to improve performance?

If yes, please can someone point in the direction to implement the calculation group.

Thanks,

AnthonyJoseph

[ppm1]

Calculation Groups will make your life as the report developer easier and also give you some good options for functionality, but they won't really improve performance of your report pages. Here are a couple good links to get started.

Calculation Groups - SQLBI

Add DAX calculation groups to Power BI Desktop models - Training | Microsoft Learn

Pat