cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

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:

Unbenannt.JPG

 

What i want is this: 

 

Unbenannt.JPG

 

The measure i have for AVG Forecast ist this: 

Unbenannt.JPG

 

 

The measure for [SKU Count] is this: 

Unbenannt.JPG

 

 

 

The example file is here:

https://wetransfer.com/downloads/c213bc1519a36dec70a7838df9849a6a20200525175000/a5db0cdb9e29c64016df...

 

Any ideas? 

 

Thanks guys!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User VII
Super User VII

Re: Summing up average Measure

@HR303 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!






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

1 REPLY 1
Highlighted
Super User VII
Super User VII

Re: Summing up average Measure

@HR303 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!






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Top Solution Authors