Upgrade to First Class with Calculation Groups for Power BI
summary
Calculation groups replace dozens of duplicate measures by using a SelectedMeasure placeholder so one time‑intelligence or statistic definition applies to many metrics. Creation works in Tabular Editor (free and commercial) and now in Power BI Desktop’s preview model explorer; Desktop shows a new UI, Tabular Editor speeds scripting and deployment. Watch that enabling them will disable implicit measures, use the hidden ordinal hidden sort column to order items, set group precedence for multiple groups, and beware sideway recursion and multi‑selection returning the original measure.
AI-written summary · about
chapters (11)
- 0:00Calculation groups intro
- 2:17Simplify measure management
- 9:34History of calculation groups
- 10:16Enable in Power BI Desktop
- 16:03Create first calculation group
- 23:31Tabular Editor for faster dev
- 27:30Customize measure formats
- 30:56Multiple calculation groups
- 37:01Advanced DAX pitfalls
- 43:33Why use calculation groups
- 48:15Q&A
related talks
01h 08mAdvanced Modelling and Calculation Using the Power BI Designer
48mCombine Power BI with External Tools
51mData modeling for experts with Power BI
43mBecome a Power BI Data Modeling Wizard using Tabular Editor 3
50mThe Path to Success with Power BI: Best Practices
48mTime Intelligence in Power BI
47mPower BI Meets Programmability – TOM, XMLA, and C#
45mMagnificent 7 - Simple Tricks to boost your Power BI Development