Question

You are building an enterprise semantic model with more than 40 base measures. Business users want to view every measure with three optional adjustments applied through a single slicer: 'Actual', 'Currency Converted' (multiply by a stored exchange rate), and 'Rounded to Thousands'. You want to avoid creating 120 duplicate measures. Which feature should you use, and what DAX construct is required inside each calculation item?

Accepted Answer

A calculation group, using SELECTEDMEASURE() inside each calculation item so the item's expression applies to whichever base measure is on the visual

Answer

A field parameter, using SELECTEDVALUE() inside each measure to detect which parameter option the user picked

Answer

A calculation group, using SUMMARIZECOLUMNS() inside each calculation item to re-aggregate the base measure at the visual grain

Answer

A set of role-based RLS filters, using USERNAME() to switch which measure version each user sees