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 
Please check this link

  • Mtelf24's avatar
    Mtelf24
    Helper I
    5 years ago

    Hi Anonymous That is using summarized data into a different table and a calculated column. My data is not summarized and if I do summarize it I'm concerned I won't then be able to filter it by fields on the original dataset such as date. If I do need to summarize I'd rather do it inside a measure if possible using SUMMARIZE()