You create the following worksheet.
The Pick Measure parameter contains the following list of values.
Users can select a value from Pick Measure to change the visualization to show either the Sales measure or the Profit measure.
Which formula is used in the SelectedMeasure calculated field to switch between measures?
The formula used in the SelectedMeasure calculated field to switch between measures should be a CASE statement that evaluates the Pick Measure parameter and returns the corresponding measure. The correct syntax for this switch is: CASE [Pick Measure] WHEN 1 THEN [Sales] WHEN 2 THEN [Profit] END. This formula specifies that if the Pick Measure parameter is 1, the formula returns the Sales measure, and if it is 2, the formula returns the Profit measure. Option A correctly represents this formula.
A is correct
CASE [Pick Measure] WHEN 1 then [Sales] WHEN 2 then [Profit] END