Forum Discussion
Anonymous
2 years agoNot applicable
Dynamic comparison with two slicers
Hello !! A simple question but i can't find answer on the forum. I have a table where i have table with in columns : ID, review name and a number. (See below) What i wnat to do is a d...
- 2 years ago
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
Anonymous
2 years agoNot applicable
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,
Ritaf1983
Super User
2 years agoHappy to help 🙂