I created two matrices, one contains the main accounts and the other contains the most important details (it’s a sort of explicative matrix). You should know that the elements of the details accounts are not in the same level : other goods are in a higher level than gaming, security…that’s why I cannot drop the columns from my fact table and that’s why I created measures for each element and used the switch function. Another thing to know is that my original data is huge, and I can’t modify column from the source or anything. So I created a sample of my data and shared it in the following PBIX file. The result you see here is what I’m looking for. But I have a problem, my two matrices are not dynamic, when I select an element in one of them it doesn’t filter the other table. I tried to create a relationship between the fact table and PLMOD, but when I do that, the elements with no code (such as operational income ) disappear from my view or displays a blank value even when I used the switch formula. Is there any DAX or manipulation I can use to make the two matrices dynamic and of course keeping the order I displayed ? Thanks for your help.
Matrices relationship issue-1.pbix (137.8 KB)