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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
anoc
Regular Visitor

SUMX- row sum does not end up correct

Hi there, 

New to PBi.

A colleauge helped me with this measure where I only want the sales from orders with total value between 0 and 5000.

Ordernr=Orer no.

Omsättning 2 = Sales.

----

Oms2<5KOrder = SUMX(
        FILTER(VALUES(Orderrad[Ordernr]), [Omsättning2]>0 && [Omsättning2]<5000),
        CALCULATE([Omsättning2]
        )
    )
----
My problem is that the totals does not end up correctly.
Oms2<5K order is named SALES below.
Share is based on the same measure but displayed as % of Row-sum.
Total sales is not correct.
Share is incorrect: 42,61%+58,52%= 101,13%
 
anoc_0-1700486058560.png

 

What do i need to do different?

 

3 REPLIES 3
anoc
Regular Visitor

Since the Total sum is incorrect aswell, I don't think it's about the share. I have read about non-additive and additive measures, maybe that's whats wrong? 
What could I do to fix that?

Can you share your .pbix file (post it to drop box and share the link here)?  It is hard to diagnose the problem without being able to see all the data.

jdbuchanan71
Super User
Super User

Is your share measure possibly ignoring all orders with negative amount so you are getting more that 100%?

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.