Same measure but getting different result when it's beside another measure from a diff table.

[Newbie22]

Hi! 

I have two different tables and created one measure for each (Measure #1 and Measure #2). I need to combine them in one single table but for some reason Measure #2 is giving different results when put beside Measure #1.

I already created a relationship between the two tables but still there are invoices/values that are being filtered out on Measure #2. 

Here's the DAX I created:

(Measure #1) _Beg Balance = SUMX('Beginning Balance', 'Beginning Balance'[USD REMAINING AMOUNT])

(Measure #2) _Today's Balance = SUMX('Today''s Balance', 'Today''s Balance'[USD REMAINING AMOUNT])

Correct total should be 25,220,083.74 but in the combined table the Today's Balance is 25,216,631.19.

Here's the sample PBIX for your reference: Sample PBI - Google Drive

Thank you in advance to those who will lend their expertise and time 🤗

[johnt75]

You have some entries in beginning balance with a blank aging bucket but the corresponding aging bucket in todays balance is not blank. You can either remove the filter for blank from the combined table or add it to the table with just today's balance, not sure which is correct for your situation.

[Newbie22]

Help please?