Microsoft Certified: Fabric Analytics Engineer AssociateImplement and manage semantic models (30-35%)Medium
A data modeler is developing a complex semantic model in Microsoft Fabric. The model includes several measures that calculate sales performance across different time periods (e.g., 'Sales YTD', 'Sales MTD', 'Sales QTD'). To improve the reusability and simplify the model, the modeler wants to define a single base measure for sales and then apply different time intelligence calculations to it. Which feature should the data modeler use?
- ACalculation Groups
- BObject-Level Security (OLS)
- CRow-Level Security (RLS)
- DCalculated Columns
Show answer & explanationAnswer & explanation
Correct answer: A. Calculation Groups
Calculation Groups allow defining a single base measure and then applying various 'calculation items' (like time intelligence filters) to it, significantly reducing the number of explicit measures needed and simplifying model management.
Why the other options are wrong
- B. OLS is used for restricting access to specific tables or columns, not for abstracting measure logic.
- C. RLS is used for filtering data rows based on user roles, not for simplifying measure definitions.
- D. Calculated columns are part of the model's tables and are not designed for abstracting measure logic.
Calculation Groups
A modeling feature in Microsoft Fabric and Power BI that reduces redundant measures by allowing calculation items (e.g., time intelligence, currency conversion) to be applied to existing measures.
- Simplifies model management by reducing the number of explicit measures.
- Enhances reusability of calculation logic.
- Applied to measures at query time.
Memory trick: Group your calcs, simplify your model, make it sparkle.