Question

A semantic model contains 40 base measures (Sales, Cost, Margin, Units, etc.). The business wants each measure to also be available as Year-to-Date, Prior Year, and Year-over-Year % variants. Rather than authoring 120 additional measures manually, you want a maintainable solution that applies these time-intelligence transformations to any measure the report author selects. Which feature should you implement?

Accepted Answer

Create a calculation group with calculation items for YTD, Prior Year, and YoY % that use SELECTEDMEASURE()

Answer

Create a field parameter that lists all 40 base measures so users can switch between them

Answer

Author 120 explicit measures but organize them into display folders for easier navigation

Answer

Enable large semantic model storage format so the additional measures compute faster