Creating filter from Measure ( DAX formula )

[Anonymous]

Hello everyone ,

I would lilke to know if there is any DAX formula that could help me creating filter using those mesures.Such that i can easily switch between any of those mesures ( values ) using a filter.

Best regards, 

Kerrout Anis 

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

Below is my solution.

1.Create a table with meausre names by entering data.

2.Create a measure with SWITCH( ) function to show the different results of measures.

Measure = SWITCH(SELECTEDVALUE('Table'[Measure name]),"Measure1",[Measure1],"Measure2",[Measure2],"Measure3",[Measure3])

Here's the results.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you Stephen !

[Ashish_Mathur · Accepted solution]

Hi,

You need to use Field Parameters - Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Docs.

Hope this helps.

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

Below is my solution.

1.Create a table with meausre names by entering data.

2.Create a measure with SWITCH( ) function to show the different results of measures.

Measure = SWITCH(SELECTEDVALUE('Table'[Measure name]),"Measure1",[Measure1],"Measure2",[Measure2],"Measure3",[Measure3])

Here's the results.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.