Using a Parameter as a filter and in calculated measures

[hellfire45]

So I am coming from Tableau.

In Tableau you can create a parameter that can be effectively used as a drop down box for filtering a dashboard.

Then you can have calculated measures to say like IF PARAMTER A = "Qty" then (use a measure containing quantity) else

IF PARAMTER A = "Dollars" then (use a measure containing # Value) else etc etc etc

In other words, IF I filter the paramter to "Qty", because I am using that calculated measure described above, all the charts would show quantity as their values.  IF I filter the paramter to "Dollars" then all the charts show dollars, etc...

Any ideas as to how this is done in Power BI?  Thanks!

[v-juanli-msft]

Hi @hellfire45 

Would you like this result?

If so, create a table

Then create a measure

Measure =
SWITCH (
    SELECTEDVALUE ( 'parameter table'[parameter to select] ),
    "Qty", [Measure_quantity],
    "Dollars", [Measure_value]
)

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.