Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Compare column value to its total average

Hi, I would like to achieve something like this: Where Rank = IF(value>Average(value),"Top","Bottom") For now, i only have Type and Value Column I cant seems to obtain a constant value for a...
Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi Anonymous

     

    Try this for your calculated column:

     

    'Average(Value)'=AVERAGE(Table1[Value])

     

    where Table1 is the name of the tale you are showing

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

Hi Anonymous

 

Try this for your calculated column:

 

'Average(Value)'=AVERAGE(Table1[Value])

 

where Table1 is the name of the tale you are showing