Question

An analytics engineer has built two calculation groups in a Fabric semantic model: one named 'Time Intelligence' (containing items like YTD, MTD) and another named 'Currency Conversion' (converting measures to EUR and USD). Users report that when they apply a YTD calculation item together with a EUR conversion item on the same visual, the results are inconsistent depending on which group's logic runs first. The engineer must ensure that time intelligence is always evaluated before currency conversion is applied. What should the engineer configure?

Accepted Answer

Set the Precedence property of the 'Time Intelligence' calculation group to a higher value than the 'Currency Conversion' calculation group

Answer

Set the Ordinal property on each calculation item in the 'Time Intelligence' group so YTD sorts first alphabetically

Answer

Merge both calculation groups into a single calculation group so the items evaluate in list order

Answer

Set the Precedence property of the 'Currency Conversion' calculation group to a higher value than the 'Time Intelligence' group