Easy Tech TutsHow to Use Calculation Groups in Power BI DAX Easily 2026
By Impran M N
Writing a separate YTD, MoM, and prior-year DAX formula for every single measure in your model quickly bloats your file and makes maintenance painful. This guide shows how to use Power BI's native calculation groups to write one reusable formula that applies across every explicit measure. You'll learn the SELECTEDMEASURE() function, dynamic format strings, and how to expose your new calculation items as an interactive slicer.
01Open the Model view and create a calculation group
Click into the Model view tab, then click the Calculation group icon in the top ribbon and confirm the implicit measures notice to unlock the design canvas.
02Rename the group and default column
Rename the new calculation group to something like Time Intelligence, and rename its default column to Period.
03Add a Current calculation item
Keep the first default item named Current using the baseline SELECTEDMEASURE() expression.
04Write YTD and Prior Year items
Create new calculation items using formulas like CALCULATE(SELECTEDMEASURE(), DATESYTD('Calendar'[Date])) for YTD and SAMEPERIODLASTYEAR for prior year comparisons.
05Apply dynamic formatting and deploy
Toggle Dynamic Format String for percentage-based items, then drag your new Period column into a Slicer visual and drop your base measures into a Matrix to see them calculate dynamically.
Frequently asked questions
What does SELECTEDMEASURE() actually do?
It's a pass-through expression that dynamically inherits whichever measure is currently placed on the visual, letting one calculation item apply to any metric.
Why use calculation groups instead of separate measures?
Calculation groups let you write a single reusable DAX formula that scales across every explicit measure instead of duplicating logic for each one.
Can I format some calculation items as percentages and others as currency?
Yes, use Dynamic Format String in the properties drawer to apply conditional formatting per calculation item.
Do calculation groups disable other measures in my model?
Power BI shows a notice about implicit measures when you first create a calculation group, since it restricts using unaggregated fields directly in visuals.
Watch the full walkthrough
The same steps, demonstrated on screen from start to finish.
