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

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
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