cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
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])

 

CountryAverageM_MeasurePTIM_UserWeightM_MeasurePTIWeight
127.1966217399.17%1.60%1.59%
2323.350072432.48%2.00%0.65%
31.432356916100.00%21.60%21.60%
4191.72285930.20%7.20%0.01%
5155.49665430.00%4.00%0.00%
645.9348328599.21%1.20%1.19%
740.8160948699.17%2.00%1.98%
860.0549355698.85%4.00%3.95%
90100.00%2.00%2.00%
10154.93434424.90%2.40%0.12%
11162.65366730.12%8.00%0.01%
12112.150918296.01%43.20%41.48%
13262.97869970.40%0.80%0.00%
   Current5.74%
   Goal74.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
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


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

@ me in replies or I'll lose your thread!!!

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Resolver I
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?

 

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

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