Forum Discussion

AnthonyJoseph's avatar
AnthonyJoseph
Resolver III
3 years ago

Calculation groups possibility to improve performance

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