Measure showing wrong subtotal

[Anonymous]

HI, 

I have measure that shows wrong subtotal when placed in matrix visual. I have one Payment table with CaseID (not unique), Value, InvoiceDate. Other Invoice table has CaseID (not unique), Value, PaymentReceivedDate.

When I place measure in matrix with CaseID rows show correct measure results, but subtotals do not. 

PBI file with sample

So 

UpsaleAmount:=

VAR InvoiceAmount=
CALCULATE(
SUM(InvoiceTable[InvoiceAmount],
USERELATIONSHIP(InvoiceTable[InvoiceDate], Calendar[Date])
)

VAR PaymentReceivedAmount=
CALCULATE(
SUM(PaymentTable[PaymentReceivedAmount]),
USERELATIONHIP(PaymentTable[PaymentReceivedDate], Calendar[Date])
)

RETURN

IF(InvoiceAmount<PaymentReceivedAmount, 
PaymentReceivedAmount - InvoiceAmount, 
BLANK())

[Brysonds]

When I exported the matrix to .csv from your Power BI app, the column totals matched what you are showing in Power BI. 

Is there any chance some of the cells in excel weren't being picked up?

[Anonymous]

Check columns named 13_TI_Total Payments Received and 12_Upsale_Total Payments Received. This is where error shows.

[Anonymous]

I have tried placing all transactions into one table and doing calculations over them, but I just do not have idea how to solve this.

[Anonymous · Accepted solution]

Thanks for effort, solution to problem is at this link Final Word On Measure Totals.