Forum Discussion
Displaying Average instead of Sum
Hello community,
I am working on a Matrix where I want to see the sum of a measure I created called "Average Sales Price"
Right now it's just displaying the average of everything. I want to see the overall sum of the average sales price of all of these parts for each section, and the sum of the overall average sales price of the sections for each sytem (name of which I blacked out for privacy purposes).
When I go to my average sales price value it does not give me an option to summarize
Any advice on how to achieve this, or if it's achievable at all would be appreciated.
Thanks
6 Replies
- amitchandak
Super User
Anonymous , Based on what all level do you want sum
Sumx(Summarize(Table, Table[TG System Group], Table[Level one column], "_1", [Your Avg Measure]) , [Measure])
Avg of Sum : https://youtu.be/cN8AO3_vmlY?t=22980
Hi, Anonymous
You just put the Avg metric into SUMX, and that's it
Sum of Avg Sales Price = SUMX('Table', [Average Sales Price])Here's a comparison, you can take a closer look at what's the difference, the total is aggregated, but it's still the average between them.
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Ashish_Mathur
Hi,
Share the download link of the PBI file.
Hi, Anonymous
Based on your information, I create a table:Maybe you can create a measure to calculate total value:
Sum of Avg Sales Price = SUMX('Table', [Average Sales Price])Then put it in Value, here is my preview:
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
