Displaying Average instead of Sum

[GSB0302]

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

[v-yohua-msft]

Hi, @GSB0302 
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.

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[amitchandak]

@GSB0302 , 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

[GSB0302]

Bumping this because I am still having this issue. I attempted this solution, but the totals for the section don't look like they're adding up correctly? Please any help here would be appreciated. I included the measure I createad to show.

[v-yohua-msft]

Hi, @GSB0302 

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.

[GSB0302]

This does not work