Question

You built a calculation group named 'Time Intelligence' with items for MTD, QTD, and YTD in an enterprise semantic model. Business users report that when they apply the 'YTD' calculation item to a non-additive measure such as [Distinct Customers], the result is misleading because a year-to-date accumulation makes no logical sense for that metric. You want the calculation items to apply only to a defined set of additive measures and return the unmodified base measure for all others, without creating separate calculation groups. Which DAX approach inside each calculation item expression best achieves this?

Accepted Answer

Use SELECTEDMEASURENAME() in an IF condition to check whether the current measure is in an allowed list, and return SELECTEDMEASURE() unchanged when it is not, otherwise apply the time-intelligence CALCULATE.

Answer

Set the calculation group Precedence property to a higher value so non-additive measures are automatically excluded.

Answer

Add a dynamic format string to each calculation item so non-additive measures display a blank format.

Answer

Enable the 'Discourage implicit measures' property on the calculation group to block [Distinct Customers] from being affected.