Finding the differences between 2 identical tables filtered differently through slicers

Hi  drem 

You can refer to the following solution.

1.You can create two tables, then put the values of the two tables to two slicers.

Slicer 1 = SUMMARIZE('Table',[Occupation])

Slicer 2 = SUMMARIZE('Table',[Occupation])

2.Create the the following measures.

Measure_Slicer1 = IF(SELECTEDVALUE('Table'[Occupation]) in VALUES('Slicer 1'[Occupation]),1,0)

Measure_Slicer2 = IF(SELECTEDVALUE('Table'[Occupation]) in VALUES('Slicer 2'[Occupation]),1,0)

put the measure_slicer1 to the table visual filter(the table is filted to the doctor)

put the measure_slicer2 to the table visual filter(the table is filted to the nurse)

put the measure3 to the table visual filter(the table is filted to the difference)

Output

 

Best Regards!

Yolo Zhu

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