Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Total of average calculation.

Hi All,

 

The square feet - A to F is in average but I want the total to be sum of average (Square Feet A to F). The total figure showing for the square feet - 1313.83 is the average of A to F. I actually want the total figure to be the sum of A to F .i.e 7883. Please assist.

 

Olumeedeh_1-1657673826076.png

 

Cheers.

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Anonymous,

It seems like a common measure total level calculation issue caused by multiple aggregations.

For this scenario, I'd like to suggest you take a look at the following blog to know more about this scenario and how to solve it:

Measure Totals, The Final Word  

If the above also doesn't help, please share some dummy data with more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

Still looking out for solution. Please

amitchandak
Super User
Super User

@Anonymous , a new measure

if Sqaure Feet is a column

measure=

Averagex(Values(Table[Name]) , Calculate(Sum(Table[Sqaure Feet])) )

 

 

if Sqaure Feet is a measure

measure=

Averagex(Values(Table[Name]) , [Sqaure Feet] )

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Thank you for your time and response. Square feet is originally a column. But the provided solution did not resolve the issue.

 

Anonymous
Not applicable

Hi @Anonymous,

It seems like a common measure total level calculation issue caused by multiple aggregations.

For this scenario, I'd like to suggest you take a look at the following blog to know more about this scenario and how to solve it:

Measure Totals, The Final Word  

If the above also doesn't help, please share some dummy data with more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

Anonymous
Not applicable

Thank you @Anonymous

Anonymous
Not applicable

Hello @Anonymous, @amitchandak, @v-polly-msft

 

I have this measure SqFt = AVERAGE(BuildingProductions[Quantity]), but the total for the measure SqFt is showing the average of the total i.e. 6,470.25 which is not correct. I need it to return the sum all the values in the SqFt.

 

Please assist.

 

Thank you.

 

Olumeedeh_0-1660583384465.png

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors