Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculate ratio

Hi,   I need to calculate the ratio of some fields. I have the following data, this is the structure of the data.  ID Numbers Date Hour 1 2 05-13-2020 10:00 1 1 05-13-2020 11:00 ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

You could a default SUM aggregation on Number and use "Show as...Percent of grand total".

 

Anonymous 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Greg_Deckler Thank you for your reply.

    I know I can use a percent of grand total, but I want a measure that's calculation the average of all the ratio's of all ID's. And I can't do that with the "percent of grand total" function. Hope you understand my question, sorry for my garbage English.

    • az38's avatar
      az38
      Community Champion
      6 years ago

      Hi Anonymous 

      try a measure

      Measure = 
DIVIDE(
CALCULATE(SUM(Table[Numbers]), ALLEXCEPT(Table, Table[ID]) ),
CALCULATE(SUM(Table[Numbers]), ALL(Table) )
)