Forum Discussion

Topjacket's avatar
Topjacket
Helper I
4 years ago
Solved

Matrix conditional formatting based on comparison to overall average

Hello   Sorry if I have missed something but I have tried searching and figuring it out myself but I am struggling with this one.   I have a matrix which shows "Category" in the columns and "Empl...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Topjacket 

    Color Code = 
VAR AvgOfAll = Calculate(AVERAGE(table[value]),all(table))
Var Avg = Average(table[value])
RETURN SWITCH(TRUE,
              Avg/AvgOfAll >= 10, "Red",
              Avg/AvgOfAll >= 5 , "Amber","")

    Use this measure in the conditional formatting.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Topjacket 

Color Code = 
VAR AvgOfAll = Calculate(AVERAGE(table[value]),all(table))
Var Avg = Average(table[value])
RETURN SWITCH(TRUE,
              Avg/AvgOfAll >= 10, "Red",
              Avg/AvgOfAll >= 5 , "Amber","")

Use this measure in the conditional formatting.

  • Topjacket's avatar
    Topjacket
    Helper I
    4 years ago

    Thanks very much for this.