Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Slicer dropdown to filter area data and hide rows in Matrix

Hello to all,   When using a slicer dropdown to filter data, let's consider a scenario where there are 5 Multi Areas (A, B, C, D, and E), each having 4 districts, resulting in a total of 20 distric...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    I created a workaround using this DAX and it solved my problem

    CF = IF(HASONEVALUE(Tab1[Dist]), BLANK(), 'Tab3'[M1])
     
    THANKS Anonymous  Anonymous  for the support.
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thank you Anonymous , but it did not worked for me,  i still get all the rows with/without the values in the matrix

 

view is like this if I filter Area = A

wanted to add that M1- M4 are calculated measures  

 

VIEW I need.