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")
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello Mtelf24 
    If the below output is expected then you can try this measure.

    AverageRetAboveBelow =
    VAR averageRevenue =
    CALCULATE(
    [Retention Measure],
    ALL( Opportunities[SalesPerson] )
    )
    RETURN
    IF (
    [Retention Measure] >= averageRevenue,
    "Above Average",
    "Below Average"
    )

    If it's not as expected then please share the expected output.