Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
Still looking out for solution. Please
@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] )
Thank you for your time and response. Square feet is originally a column. But the provided solution did not resolve the issue.
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
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.
User | Count |
---|---|
98 | |
91 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |