Forum Discussion

hellfire45's avatar
hellfire45
New Member
6 years ago

Using a Parameter as a filter and in calculated measures

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!

Need Help

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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.