How to create a measure depending on the hierarchy level in the matrix?

[MK3010]

Hi @Harris,

You can also refer to below link where we have DAX calculation for hierarchy

How to do Conditional Format referring to group average - #9 by MK3010

How to do Conditional Format referring to group average Part II

Hi @ammu Hope the above updated DAX code is what you were looking. I have used with the new dataset and it is skipping cost center 1008. Below screen shot FYR. [image]

How to do Conditional Format referring to group Net result average

Hi @ammu, See if this helps you resolve it. Av. multi = SWITCH( TRUE(), ISINSCOPE( Facility[Code] ), AVERAGEX( CALCULATETABLE( VALUES( Facility[Code] ), ALLSELECTED( Facility[Code] ) ), [Net Result] ), ISINSCOPE( Facility[RAC Grouping] ), AVERAGEX( ALLSELECTED( Facility[RAC Grouping] ), [Net Result] ), [AverageNR] )