Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin 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.
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.
----
What do i need to do different?
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.
Is your share measure possibly ignoring all orders with negative amount so you are getting more that 100%?
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 79 | |
| 48 | |
| 35 | |
| 31 | |
| 27 |