Switch True DAX to select data to show

[hidenseek9]

Hello Power BI Community, 

I would like to use Switch True DAX to select metric to show the necessary data depending on the needs.

For instance, if a user selects "Sales", the dashboard will show the sales data

and if the user selects "Costs", the dashboard will show the cost data. 

Please refer to below YouTube video and this is exactly what I would like to do.

Switch True Measure Video 

I understand how to set up Switch True DAX from this video, but what I do not understand is 

how this guy set up [metrics selected] measure. 

Can anyone guess how to set up this measure?

Thanks,

H

[VasTg · Accepted solution]

@hidenseek9 

Refer to these posts.

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/m-p/500...

If it helps, mark it as a solution

Kudos are nice too

[VasTg]

@hidenseek9 

Create a table as below with values as Sales, Costs, etc and use them as a slicer. 

Sales

Costs

In your switch measure, use a variable to get the selected value and use in place of "Metric Selected"

Var selected_value = SELECTEDVALUE(COLUMN)  //Slicer column)

If it helps mark it as a solution

Kudos are nice too