Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Sum of Measure on a hierarchy

Hello, I hope you can help me with this problem.


I have a table with a hierarchy of three levels (item, description and unit of measure), I need to create a measure that adds only the last hierarchy, the result I need is 7.12% and when I make my DAX formula:


Weighted Variation Sum = sumx(values('PURCHASE ANALYSIS'[unit of measure]),[Weighted Variation])

The result that comes out is 7.18%. 😞

but if I do it the sum comes out 7.12%

I do not know what I'm doing wrong. Thank you so much 🙂





If you need more info i I'll be on the lookout. Thanks!

Super User
Super User

@Lucy_Ramirez First, please vote for this idea:

This looks like a measure totals problem. Very common. See my post about it here:

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:


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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.