Two different dynamic text slicer selection in one measure

[PowerEti]

Hello,

I wrote the following dax formula:

Effects in Vol = Calculate([Vol Share],Phase2[Phase2]="LE2")*Calculate([Volume],Phase[Phase]="ACT",ALL(SKU))-Calculate([Volume],Phase2[Phase2]="LE2")

There are two slicers on the page that are the same and return each phase. I am using these slicers to make comparisons between two phases but I would like to make this DAX measure dynamic to be able to chose the comparison phase.

The two slicer are one column with the following value:

Phase 1

ACT

BUD

LE1

LE2

Phase 2

ACT

BUD

LE1

LE2

Do you have an idea on how to make this measure dynamic based on the slicer selection please ?

Thank you,

[v-xiaosun-msft]

Hi @PowerEti ,

According to your description,do you need to select values of slicer "Phase 1", then it only display the result of "Phase 1", and select values of slice "Phase 2", then it only display the result of "Phase 2"?

Could you please describe more clearly? And it will help if you can provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.  

Best Regards,
Community Support Team _ xiaosun

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

[PowerEti]

Hello,

Thank you for your answer.

It is a bit complicated to give a simplified model on that but I will try. what I would like to do is quite simple but it seems to be not so straightforward with dax. I just want to replace "LE2" and "ACT" with something dynamic. So that when I change the selection in the slicer Phase "LE1" it will replace "ACT". And same for Phase2 so that I can really compare what I want. I tried using selectedvalue but couldn't make it work.