cancel
Showing results for
Did you mean:
Highlighted
Resolver I

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 2
Highlighted
Super User IV

Re: Calculate Measure not returning proper sum

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

---------------------------------------

I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Super User!

Highlighted
Resolver I

Re: Calculate Measure not returning proper sum

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?

Announcements

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors