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

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
Teddibeer
Helper I
Helper I

sum changes when adding measures

Hi all,

 

we have a strange issue with out Power BI reporting.

We have 2 data sources correctly linked to each other.

With these 2 data sources we have created seperate measures to show us data.

 

the measures are used for; Sum amount, sum cost, sum cost part 1, sum cost part 2.

As soon as we add sum cost part 1 and 2 to the matrix table, the total from sum cost (500K) drops down to (200K).

can someone tell me where i could find this issue?

if we remove the measure for sum cost part 1 and 2 we get the result of 500K back but we need to see sum cost part 1 and 2 in that matrix

2 REPLIES 2
Greg_Deckler
Community Champion
Community Champion

@Teddibeer Difficult to determine the cause. Perhaps you can provide some additional information or images of what you are seeing?



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!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Hi Greg, as requested hereby a picture of the situation.

a small part is in dutch but that doesnt affect the formula luckily.

let me know if you require more information from my side

 

Teddibeer_0-1710486065656.png

 

Helpful resources

Announcements
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.