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...
Need Help
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.