Forum Discussion

Mtelf24's avatar
Mtelf24
Helper I
5 years ago
Solved

Above/Below Average Classification

I have two formulas to calculate the overall average of two bits of data in my dataset.   The first:   AverageRetention =  DIVIDE([Won Count Measure],[Won Count Measure] + [Lost Count Measure]) ...
  • Mtelf24's avatar
    Mtelf24
    5 years ago

    OK I worked out the formula I wanted to do for the average comparison for the revenue and it is working how I want it. Now I'm going to see if I can apply the same for the retention %...

     

    AverageRevenueCompare =
    VAR averageRevenue =
    CALCULATE( AVERAGE (Table[Revenue]),ALL(Table[SalesPerson]))
    RETURN
    IF (AVERAGE(Table[Revenue]) >= averageRevenue, "Above Average","Below Average")
Mtelf24's avatar
Mtelf24
Helper I
5 years ago

OK I worked out the formula I wanted to do for the average comparison for the revenue and it is working how I want it. Now I'm going to see if I can apply the same for the retention %...

 

AverageRevenueCompare =
VAR averageRevenue =
CALCULATE( AVERAGE (Table[Revenue]),ALL(Table[SalesPerson]))
RETURN
IF (AVERAGE(Table[Revenue]) >= averageRevenue, "Above Average","Below Average")
  • Mtelf24's avatar
    Mtelf24
    Helper I
    5 years ago

    Applying a similar formula doesn't work for 

    AverageRetention =  DIVIDE([Won Count Measure],[Won Count Measure] + [Lost Count Measure])

    So I'm still working that out.

    But the formula I posted in message 4 works great for the revenue field.