Calculation Groups – easy calculations with multiple measures at the same time
This tutorial describes using of Calculation Groups in Power BI.
You will need the Tabular Editor external tool, which can be downloaded from here, for free.
In which situation would you appreciate this feature?
Let´s have some measures, for example total, average and highest revenue.
These values are without tax. But you need them with 21% tax (or usually something more complex like Time Intelligence etc.).
Normally, you will need another version for all measures (Total revenue with tax, Average revenue with tax, Max revenue with tax), and the number of measures would multiple with any other similar calculation.
It would be much easier with Calculation Groups. Calculation Groups are “general” calculations, defined once, and used for all affected measure.
So we can simply get this result, when only having three original measures and one Calculation Group.
Let´s open the Tabular Editor and create a new Calculation Group:
Then a new Calculation Item:
Name it nicely and write a DAX formula like this. It´s important to use the SELECTEDMEASURE in a part of formula, where the original measures will be used.
- SELECTEDMEASURE()*1.21
Similarly you can do more calculations, like “Without tax” etc.
Confirm.
Now there is a new group, containing the “Name” item. You can place this item into visual, which recalculates original measures.
You can simply change the layout of visual, so as it looks exactly as you need.
The example file can be downloaded from here: