topic Measure for above and below average with conditional formating in DAX Commands and Tips

Measure for above and below average with conditional formating

sriramk — Sat, 16 Apr 2022 13:55:25 GMT

Please help me to solve

Re: Measure for above and below average with conditional formating

tamerj1 — Sat, 16 Apr 2022 14:14:10 GMT

1. IF ( MAX ( Table1[Revenue/Cost] ) >= [Average Rev/Cost] ), "Above Avg", "Below Avg" )

2. MAX ( Table1[Revenue/Cost] ) >= [Average Rev/Cost] )
then use the measure in the conditional formatting >= 1 for green and 0 for red

3. DIVIDE ( MAX ( Table1[Revenue/Cost] ) - [Average Rev/Cost] , [Average Rev/Cost] )

4. Please clarify further

Re: Measure for above and below average with conditional formating

Whitewater100 — Sat, 16 Apr 2022 22:55:04 GMT

Hi:

Please see link for the figures (they are in either "Result Table" or Sum Table".) I hope this is what you are looking for. My average is higher than yours $2.85 v $2.24...

https://drive.google.com/file/d/14fcOeKrRrKhdClu7gIcyra7F4Rdx4d9W/view?usp=sharing

Re: Measure for above and below average with conditional formating

sriramk — Mon, 25 Apr 2022 12:13:28 GMT

Hi, Thank you very much for the details.

Clarification for S.No.4 :
If the deviation from Average is more than 3%, to show the product name and store ID in the report on selected date.