change back ground color of matrix based on field value

[Anonymous]

hiiii all ......im new to power bi . I am having data with error logs and site id .

i want a matrix that shows error count with differnt background color based on average error count.

 I cant change the color based on average  but the color changes with constant value.

iam sharing a sample data

siteid  error

1	a
2	ab
3	abc
4	a
5	ab
1	abc
2	a
3	abc
4	ab
5	a

my measures are  

count of error = COUNT(Table1[error])

siteidcount = DISTINCTCOUNT(Table1[siteid])

avg error count = [count of error]/[siteidcount]

i used this measure as field value

color change field= IF([count of error]<([avg error count]),"yellow")

i get

i cant see a change in color ......but if give 

color change field = IF([count of error]<2,"yellow")

avg error count value is 2 and my color changes

if i give 

color change field = IF([count of error]=[avg error count],"yellow") i get this

need your please help..... want to change background color in value of error based on average error count

[Anonymous]

thanks bro ... it worked .Can u tell me what mistake i made

[NikhilChenna]

hi @Anonymous , You missed to add the ALL(). thats why you were not able to achieve the desired output.

Regards,

Nikhil Chenna

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

[FreemanZ]

average is the average for all, so we add ALL() to ignore the filter contexts, row and column headers in your Matrix Visual. 

[Anonymous]

when i use page filter siteid ....average count changes but the background color wont since we use All function......i want to color for the page filter as well

[NikhilChenna]

Hi @Anonymous , I think below is the solution for you.

I tried it myself,

1. Count of error =COUNT('Table (3)'[error])

2. Avg error count = CALCULATE(DIVIDE([count of error],[siteidcount]),ALL('Table (3)'))

This is the additional thing i added in the avg error count.

3. Count of error divided by siteidcount =

DIVIDE([Count of error], [siteidcount])

Create this measure

4. color change field =

IF([Count of error]<'Table (3)'[Avg error count],1,0)

5. Add this conditional formatting.

6. below is the output i think you need.

Regards,

Nikhil Chenna

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

[FreemanZ · Accepted solution]

try to change your measure to

color change field = 

VAR AvgForAll = 

CALCULATE( [avg error count], ALL())

RETURN

IF([count of error]=AvgForAll,

"yellow")