I have been stuck in a situation, and I appreciate any help.
I have a fact transaction and a DimSaler table. I want to make a comparison between 2 people in my organization, so I make another DimSaler called Comparison DimSaler to calculate the difference between 2 people. This is a sample of my data model.
This is a sample of the matrix
I have 2 slicers to select saler for the matrixs. The first matrix shows sale information of a saler, and the second martix shows other saler. The third table shows the difference sale amount between 2 people. Now, I want to filter on the third table to take only the intersection between matrix 1 and matrix 2, so the third matrix should only contain book, shampoo, and shoes.
I can not post my sample pbix file to this post, so this is a link I refered to created the first 2 matrix. https://www.youtube.com/watch?v=hu_fOtZDJwU
Thank you so much for your help.