How to do Conditional Format referring to group average

MK3010 · September 18, 2020, 1:06am

I have added sum data to meet your criteria and You can use below DAX to do achieve your result.

CriteriaCheck = 
VAR tempCal = CALCULATE( [Occupancy%] , ALLEXCEPT( Facility,Facility[RAC Grouping],Facility[Metro/Regional]) )

RETURN
IF(
    [Occupancy%] < tempCal ,
    -1 ,
    BLANK()
)

And use below conditional formatting.