Calculate Measure not returning proper sum

[orangeatom]

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.

[Greg_Deckler]

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

[orangeatom]

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?