Highlight below or above the average price

[mjmjn2611]

Hi, 

I want to create a measure to highlight below or above the average price.

For example 

Customer       Price      Check

A                    5            below average ==> red

B                     7           above average ==> green

C                     6

[selimovd]

Hey @mjmjn2611 ,

you can add the color as a calculated column:

Check = 
VAR vRowPrice = myTable[Price] 
VAR vAveragePrice = AVERAGE(myTable[Price])
RETURN
SWITCH(
    TRUE(),
    vRowPrice < vAveragePrice, "red", 
    vRowPrice > vAveragePrice, "green"
)

Then you can use that column for the conditional formatting:

And that's then the result you get:

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic