Forum Discussion

damit23183's avatar
damit23183
Microsoft Employee
6 years ago
Solved

Average formula

Hi,   Need help with AVERAGE formula,   I would like to calculate below condition,   ID                   ServiceName        %Value     --> Column Name 1                             A         ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi damit23183 ,

    Could you please mark this post as Answered since the problem has been resolved by yourself? Thank you.

     

    Best Regards

    Rena

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Not sure if I am missing something here but that should literally be able to be accomplished using the default Average aggregation in a table. Are you saying that you want the first table displayed exactly like (no aggregation on %Value) that but once something is selected you do want the average? If that is the case, create a measure that uses HASONEVALUE as an IF check and if there is one value, return the Average, otherwise, use a MAXX on the FILTER of your table where the [ID] matches.