Forum Discussion
jyaul786
Helper II
Helper IIHide/remove matrix rows
Dear Friend, i have one table with Level1,Level2,Level3,Level4 and value, i want to display in Matrix with hierarchy. Data: Level1 Level2 Level3 Level4 value Asset current bank bank1 ...
jyaul786Helper II
Helper IIi tried your measure but i have still empty rows as:
measure=
SWITCH(
TRUE(),
and(ISINSCOPE('Table test'[Level3]),ISBLANK(VALUES('Table test'[Level3]))),BLANK(),
and(ISINSCOPE('Table test'[Level4]),ISBLANK(VALUES('Table test'[Level4]))),BLANK(),SUM('Table test'[value])
)
DOLEARY85
Resident Rockstar
Resident RockstarStrange 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 👍
- Ahmedx
Super User
your method will only work if you create a hierarchy
- DOLEARY85
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.
- Ahmedx
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 work
