- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
06-20-2024 07:27 AM | |||
05-02-2024 11:36 AM | |||
01-18-2024 12:10 AM | |||
06-25-2024 03:02 PM | |||
07-24-2024 12:31 AM |
User | Count |
---|---|
87 | |
81 | |
53 | |
38 | |
35 |