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
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
6 years ago

Anonymous 

 

You may use the measure below.

Measure =
DIVIDE (
    AVERAGEX ( VALUES ( Table1[ID] ), CALCULATE ( SUM ( Table1[Numbers] ) ) ),
    CALCULATE ( SUM ( Table1[Numbers] ), ALLSELECTED ( Table1[ID] ) )
)

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you both v-chuncz-msft and az38 . Both of the solutions works with a measure. 

     

    Is this formula also possible to use as an extra column instead of a measure? 

    • az38's avatar
      az38
      Community Champion
      6 years ago

      Anonymous 

      yes, it should be fine