Forum Discussion
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.
Cheers.
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
6 Replies
- amitchandak
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] )
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
