Forum Discussion

Frequent Visitor

4 years ago

Solved

Have Measure in Matrix Return Blank for Selected Rows in a Particular Hierarchy Level

Hi, I have some data that I would like to put in a matrix. The matrix has two hierarchy levels: 1) Scenario Parent 2) Scenario That causes it to look like this when expanded: ...

Need Help

v-kkf-msft
4 years ago
Hi fourmj ,

Please try the measure. Then show items with no data in matrix.

Measure = IF ( MAX ( '5_test_Data'[Scenario Parent] ) = "All Consulting", SUM ( '5_test_Data'[Value] ), IF ( ISINSCOPE ( '5_test_Data'[Scenario] ), SUM ( '5_test_Data'[Value] ) ) )

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Return Blank for Selected Rows.pbix35 KB

v-kkf-msft

Community Support

4 years ago

Hi fourmj ,

Please try the measure. Then show items with no data in matrix.

Measure = 
IF (
    MAX ( '5_test_Data'[Scenario Parent] ) = "All Consulting",
    SUM ( '5_test_Data'[Value] ),
    IF ( ISINSCOPE ( '5_test_Data'[Scenario] ), SUM ( '5_test_Data'[Value] ) )
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Return Blank for Selected Rows.pbix35 KB