Total of average calculation.

[Olumeedeh]

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.

Cheers.

[Olumeedeh]

Still looking out for solution. Please

[amitchandak]

@Olumeedeh , 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] )

[Olumeedeh]

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

[v-shex-msft · Accepted solution]

Hi @Olumeedeh,

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

[Olumeedeh]

Thank you @v-shex-msft

[Olumeedeh]

Hello @v-shex-msft, @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.