cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Vladimir_P
New Member

Dynamic measure option

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.

 

PBI Community.jpg

Thanks in advance!

1 ACCEPTED SOLUTION
nandic
Super User
Super User

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

View solution in original post

3 REPLIES 3
themistoklis
Super User
Super User
nandic
Super User
Super User

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

View solution in original post

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 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!