Forum Discussion
ISINSCOPE Hide Empty Rows in a Matrix Hierarchies
Community SupportHi Anonymous
I try to produce your problem.
First, i want to confirm something:
In data below, when showing level1~level7, the second row should not show on the matrix, right?
If my example is not correct, could you show me a simple one?
| level1 | level2 | level3 | level4 | level5 | level6 | level7 | value |
| A | AB | ABC | ABCD | ABCDE | ABCDEF | ABCDEFG | 1 |
| A | AB | ABC | ABCD | ABCDE | ABCDEF | ABCDEFH |
Meanwhile, you could learn How to use ISINSCOPE in Hierarchies from the following video.
DAX for Power BI - Determining Hierarchy Level (ISINSCOPE)
If you still have problems, pleas let me know.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Maggie;
Thanks for the video was so helpful, this is a complete example thaT I need to do:
Data Base
The Idea is make a visual Matrix and must work in this way:
Don´t show empty rows.
Respect the value and content in before levels
Respect the Total Value always
This is the way to show the Matrix in each change of hierarchies:
Im tryng whit this code but don´t work all well:
Medida =
IF (
SWITCH (
TRUE (),
AND ( ISINSCOPE ( Hoja6[Level 1] ), ISBLANK ( VALUES ( Hoja6[Level 1] ) ) ), BLANK (),
SUM ( Hoja6[Value] )
),
IF (
SWITCH (
TRUE (),
AND ( ISINSCOPE ( Hoja6[Level 2] ), ISBLANK ( VALUES ( Hoja6[Level 2] ) ) ), BLANK (),
SUM ( Hoja6[Value] )
),
IF (
SWITCH (
TRUE (),
AND ( ISINSCOPE ( Hoja6[Level 3] ), ISBLANK ( VALUES ( Hoja6[Level 3] ) ) ), BLANK (),
SUM ( Hoja6[Value] )
),
IF (
SWITCH (
TRUE (),
AND ( ISINSCOPE ( Hoja6[Level 4] ), ISBLANK ( VALUES ( Hoja6[Level 4] ) ) ), BLANK (),
SUM ( Hoja6[Value] )
),
IF (
SWITCH (
TRUE (),
AND ( ISINSCOPE ( Hoja6[Level 5] ), ISBLANK ( VALUES ( Hoja6[Level 5] ) ) ), BLANK (),
SUM ( Hoja6[Value] )
),
IF (
SWITCH (
TRUE (),
AND ( ISINSCOPE ( Hoja6[Level 6] ), ISBLANK ( VALUES ( Hoja6[Level 6] ) ) ), BLANK (),
SUM ( Hoja6[Value] )
),
IF (
SWITCH (
TRUE (),
AND ( ISINSCOPE ( Hoja6[Level 7] ), ISBLANK ( VALUES ( Hoja6[Level 7] ) ) ), BLANK (),
SUM ( Hoja6[Value] )
),
SWITCH (
TRUE (),
AND ( ISINSCOPE ( Hoja6[Level 7] ), ISBLANK ( VALUES ( Hoja6[Level 7] ) ) ), BLANK (),
SUM ( Hoja6[Value] )
)
)
)
)
)
)
)
)In advance thanks for your time!
- v-juanli-msft
Hi Anonymous
As tested, it seems impossible to hide the blank rows on "Row header".
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.