Forum Discussion
Hide/remove matrix rows
Strange it works with the test data you provided, without being able to view your file i'm not sure what other solution could work.
I've attached my PBIX file for you to review, hopefully it will provide some additional help:
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
your method will only work if you create a hierarchy
If you replace the hierarchy in rows of the matrix with the individual lvl 1 - 4 fields it still works in the sample PBIX file I uploaded.
it works in your file, but not in others
try my file.
I'm wondering why your file works and in others the measure doesn't workI understand why it doesn't work for me. the column is not empty. this will work:
Ah yes, apologies - i forgot to mention i also used Power Query to change the empty cells to null before using DAX, but yes this would be another way to do it without Power Query.