Dynamic measure option

[Vladimir_P]

Dear Community,

Can someone help me how to create one measure in which I can present different data (e.g. Revenue, Profit, Profit margin) based on the chosen filter?

Filter contains mentioned values (e.g. Revenue, Profit, Profit margin) and by choosing the value, data set should be switched to requested value. Also, we have new currency filter (e.g. $, €...) which needs to be reflected on the same value.

Currently, I’m using DAX and edit relationship on the slicer level to solve it. I’m hoping there is an easier way. Can anyone help, please?
Please find the visual in the picture below.

Thanks in advance!

[themistoklis]

Hello @Vladimir_P 

The following 2 sites include the information that you want:

https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...

https://www.fourmoo.com/2017/11/21/power-bi-using-a-slicer-to-show-different-measures/

[nandic · Accepted solution]

Hi @Vladimir_P ,

Instead of using edit relationship, maybe the easiest way would be to set slicer values in new tables.
This way you have clean information what slicer is in which table, how it is connected.

There are great DAX formulas like selectedvalue, all, allselected.. using them you have great power of dealing with selected values.

If this doesn't give you idea of how it should look like, please share screenshot of current model.

Cheers,

Nemanja Andic

[Vladimir_P]

Hello @nandic,

Thank you very much for the answer provided. I believe it will work but definitely need to test it. I'll let you know the results asap.

Have a nice day!
Vladimir