Forum Discussion

Vladimir_P's avatar
Vladimir_P
New Member
5 years ago
Solved

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 v...
Need Help
Tips and Tricks
  • nandic's avatar
    nandic
    5 years ago

    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

nandic's avatar
nandic
Resident Rockstar
5 years ago

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's avatar
Vladimir_P
New Member
5 years ago

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