Forum Discussion
Calculate Measure not returning proper sum
Hello,
I am attempting to create a measure that will return the sum of a few calculated measures (sourced from different tables). I have a simple Calculate function does return the correct average but i can't seem to get the sum to work. I also use a few measure on measure on measures to get to this point:
Measure_PTI = DIVIDE(([M_MeasurementTotal]-[M_MeasurementDeviation]),[M_MeasurementTotal])
Measure_UserWeight = DIVIDE([M_Users],[M_UsersTotal])
MeasurePTIWeight = [Measure_PTI] * [Measure_UserWeight]
MeasurePTIWeightPercent = CALCULATE([M_MeasurePTIWeight])
| Country | Average | M_MeasurePTI | M_UserWeight | M_MeasurePTIWeight |
| 1 | 27.19662173 | 99.17% | 1.60% | 1.59% |
| 2 | 323.3500724 | 32.48% | 2.00% | 0.65% |
| 3 | 1.432356916 | 100.00% | 21.60% | 21.60% |
| 4 | 191.7228593 | 0.20% | 7.20% | 0.01% |
| 5 | 155.4966543 | 0.00% | 4.00% | 0.00% |
| 6 | 45.93483285 | 99.21% | 1.20% | 1.19% |
| 7 | 40.81609486 | 99.17% | 2.00% | 1.98% |
| 8 | 60.05493556 | 98.85% | 4.00% | 3.95% |
| 9 | 0 | 100.00% | 2.00% | 2.00% |
| 10 | 154.9343442 | 4.90% | 2.40% | 0.12% |
| 11 | 162.6536673 | 0.12% | 8.00% | 0.01% |
| 12 | 112.1509182 | 96.01% | 43.20% | 41.48% |
| 13 | 262.9786997 | 0.40% | 0.80% | 0.00% |
| Current | 5.74% | |||
| Goal | 74.58% |
I have read a few threads and tired different solutions and I am not sure if there is an issue with the formula or if i have other issues like the model not being setup correctly.
2 Replies
This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149
Thanks! This looks very interesting and i will certainly explore it.
Two quick questions I have so far.
1) How does this handle dimensionality across the SuperGroups/Groups?
2) Lets assume that the score in the AttributeScores is a calculated measure, (example 5 users /40 total users), how does that effect the model?
