Question

You build a calculation group named 'Time Intelligence' in a Fabric semantic model. It contains items like YTD, QTD, and PY. Users report that when they apply the YTD calculation item to a measure formatted as currency (for example, $#,##0), the resulting value loses its currency formatting and appears as a plain number. You want each calculation item to keep the formatting of the base measure it modifies. What should you do?

Accepted Answer

Set the dynamic format string expression for each calculation item to SELECTEDMEASUREFORMATSTRING()

Answer

Increase the calculation group precedence value so it evaluates before the measure's own format string

Answer

Convert the base measures to use a hard-coded FORMAT() function returning a text result

Answer

Disable the dynamic format string on the calculation group and rely on the model's default format