Step:1

Create parameter [Measure Parameter] list as Sales, Profit and Unit Price

measure para.png

Step:2

Create calculation as follows [Measure Calc]

case [Measure Parameter]

when "Sales" then [Sales]

when "Profit" then [Profit]

when "Unit Price" then [Unit Price]

end


Step:3

Drag this [Measure Calc] into coloumn and drag any of dimensions into row


Step:4

Show Parameter control and select Kpis.