Forum Discussion
Dynamic comparison with two slicers
Hi Anonymous
You need to create 2 tables with reviews ( 1 for every slicer).
I created them with PQ, duplicated the table, removed unneeded columns and removed duplicates :and duplicated again a resulted table because we need 2.
The next step is to create a relationship between those tables and your fact table :
The values of those 2 tables is for the 2 wanted slicers :
The next step is to create 2 measures :
Selction 1 = CALCULATE(sum('Table'[number]),REMOVEFILTERS('Review2'))Selction 2 = CALCULATE(sum('Table'[number]),REMOVEFILTERS('Review1'))And to put them in the desired visualizationpbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Anonymous
You need to create 2 tables with reviews ( 1 for every slicer).
I created them with PQ, duplicated the table, removed unneeded columns and removed duplicates :
and duplicated again a resulted table because we need 2.
The next step is to create a relationship between those tables and your fact table :
The values of those 2 tables is for the 2 wanted slicers :
The next step is to create 2 measures :
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
HI there !
Super, many thanks for your help ! I didn't think to display all my data with measure which is much more easier ! super !!! 🙂Have a good day,
Happy to help 🙂