Forum Discussion
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.
Thank you swikritee_p for your response. I have followed your suggestion but I still can't get Table 3 to display the correct result.
Table 3 should only return 1 row "Doctor | Perform operation" because it exists in Table 2 but not Table 1. The screenshot shows it is returning all values in the combined table.
Also " You need a table with combine values " - I created a new table using the merge query (combine Table 1 and Table 2 using Full Outer Join) on column "Occupation", can you please clarify if this is correct?
If you could attach your working solution that would be great.
Thank you
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.
Thanks so much Anonymous !