Forum Discussion
Hide/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 ...
Hi,
try this measure to replace your value field in the matrix:
Value Measure= SWITCH(TRUE(),and(ISINSCOPE('Table'[Level3]),ISBLANK(VALUES('Table'[Level3]))),BLANK(),and(ISINSCOPE('Table'[Level4]),ISBLANK(VALUES('Table'[Level4]))),BLANK(),SUM('Table'[value]))
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍