Microsoft Certified: Fabric Analytics Engineer AssociateImplement and manage semantic models (30-35%)Hard
A data engineer is designing a semantic model for a global e-commerce platform in Microsoft Fabric. The model needs to support multiple currencies for sales transactions, allowing users to view sales amounts in their local currency. The raw data contains sales amounts in a base currency and a currency conversion rate table. To implement this efficiently and allow dynamic currency selection in reports, which feature should the engineer use?
- AApply object-level security to currency-specific measures.
- BUse a custom M query to transform all sales amounts into all target currencies during data load.
- CCreate multiple measures for each currency (e.g., SalesUSD, SalesEUR).
- DImplement a calculation group for currency conversion.
Show answer & explanationAnswer & explanation
Correct answer: D. Implement a calculation group for currency conversion.
Calculation groups are ideal for scenarios like currency conversion because they allow you to define a single 'calculation item' (e.g., 'Convert to USD', 'Convert to EUR') that can be applied to existing base measures, dynamically changing their context without creating numerous redundant measures.
Why the other options are wrong
- A. Object-level security is for hiding tables or columns, not for dynamic calculation changes based on user selection.
- B. Pre-calculating all currencies during data load can lead to massive data duplication and bloat, making the model inefficient.
- C. This creates measure explosion, making the model complex and hard to manage.
Calculation Groups
A feature in Tabular models (including Fabric semantic models) that allows you to define a collection of calculation items that can be applied to measures as filters, dynamically changing their behavior.
- Reduces measure explosion for common calculations (e.g., time intelligence, currency conversion).
- Applies calculation logic as a filter context.
- Requires external tools like Tabular Editor to create.
Memory trick: Group your calculations to transform measures on the fly.