How to do Conditional Format referring to group Net result average

DAX DAX Calculations
2

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]
)
2 Likes