Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Summing up average Measure

Hi guys, 

 

i have a table and i want to sum a an average measure but the total is always also the average and not the sum of the individual averages: 

 

I want to sum up column AVG Forecast:

 

What i want is this: 

 

 

The measure i have for AVG Forecast ist this: 

 

 

The measure for [SKU Count] is this: 

 

 

 

The example file is here:

https://wetransfer.com/downloads/c213bc1519a36dec70a7838df9849a6a20200525175000/a5db0cdb9e29c64016df395c77188aa620200525175022/31fba4

 

Any ideas? 

 

Thanks guys!

 

Need Help

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous try this

     

    Sum Avg Measure = 
SUMX ( VALUES ( Table[Id] ), [Your Average Measure] )

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!