Question

An analyst maintains a semantic model with 15 base measures. The business wants each measure to be viewable as Current, Year-to-Date, and Prior Year without creating 45 separate measures. Additionally, the YTD variant should display as currency while a new 'Percent of Total' variant must display as a percentage — all using the same underlying measures. Which combination of features should the analyst implement to meet these requirements with minimal measure duplication?

Accepted Answer

Create a calculation group with calculation items for each time-intelligence variant, and set a dynamic format string expression on the calculation items

Answer

Create 45 explicit measures and use the FORMAT function inside each measure to control display

Answer

Create a field parameter listing all 15 measures and apply a static format string to the visual

Answer

Enable large semantic model storage format and rely on Direct Lake to apply the formatting automatically