Dynamic comparison with two slicers

[Anonymous]

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 dynamic comparison between reviews. Thus to dothat i want i slicer wich filter all the table + a slicer wich permit me to import the number of the second review selected.

Like that i will have for exemple if i selected review 1 i have all the data of review 1 and in the second slicer if i selected review 3 i import via the mesure just the column which is the number : 

and the objective is to compare so if i can import the data of the second slicer in a column, i can do the soustraction. 
the question is : Can i import in a new column via a mesure all the value filtered by the second slicer on power bi ? 

Thanks by advance for your help,

Florian

[Ritaf1983 · Accepted solution]

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 visualization 

pbix is attached

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

[Anonymous]

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]

Happy to help 🙂