Forum Discussion

david_avgarcia's avatar
david_avgarcia
Frequent Visitor
9 months ago
Solved

Matrix Show Different Hierarchy Levels

I'm using a matrix to the display the following table: Country | Section | Header | Clause Belgium | Scope  |              | This is the scope  Belgium | Benefits | Tax       | Exemption from all ...
Need Help
  • danextian's avatar
    danextian
    9 months ago

    Hi david_avgarcia 

    Use ISINSCOPE to determine check whether a column is the level in a hierarchy of levels. In the image below, Gross Profit is already expanded but the next level in the hierarchy is not visible. A condition was applied to return the second level as blank when it is in scope and the first level is Gross Profit.

     

    IF (
    ISINSCOPE ( tbl[hierarchy2] )
        && SELECTEDVALUE ( tbl[hierarchy1] ) = "Gross Profit",
    blank,
    [pnl measure]
)

     

david_avgarcia's avatar
david_avgarcia
Frequent Visitor
9 months ago

Ok, I got showing like danextian . Instead of using a filter with that formula, that formula will be a measure and the measure should be on the values. Thank you!

 

v-nmadadi-msft's avatar
v-nmadadi-msft
Community Support
9 months ago

Hi david_avgarcia  

May I check if this issue has been resolved by the suggestion provided by danextian ? If not, Please feel free to contact us if you have any further questions.


Thank you