Forum Discussion

urpalani's avatar
urpalani
Icon for Helper II rankHelper II
8 years ago
Solved

Calculate Avg

Hi Experts,   I want to calculate the Avg that is based on WT/TE ,i am not getting the sum of Avg , When i am doing sum i am getting 29.9 + 33.8 and when i am doing Avg it is (29.9 + 33.8) / 2   ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi urpalani,

     

    Create a measure to calculate average value:

    Avg measure = SUM('Source Table'[WT])/SUM('Source Table'[TE])

    Then, your table visual looks like:

     

    Best regards,
    Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Is your Avg WT/TEU data coming from a measure?  It looks to me like your AVG WT/TEU is either raw data, or a calculated column.  If that was the case you won't get the correct answer.  If you can create a measure instead, you should get the bottom row context answer you expect.