Indicate whether data is above or below average

Hi totamum ,

First of all thanks to lbendlin  for the quick reply. I have some other thoughts to add:

(1) This is my test data.

(2) We can create a average measure.

Average Page Views = AVERAGEX(ALLSELECTED('Table'),[Page Views])

(3) We can create a conditional column or a conditional measure.

Column = 
IF (
    [Page Views] > [Average Page Views],
    "Above Average",
    IF ( [Page Views] < [Average Page Views], "Below Average", "Equal Average" )
)

Measure = IF (
    SUM('Table'[Page Views]) > [Average Page Views],
    "Above Average",
    IF (
        SUM('Table'[Page Views]) < [Average Page Views],
        "Below Average",
        "Equal Average"
    )
)

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.