Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Measure showing wrong subtotal

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())

 

Need Help

4 Replies

  • Brysonds's avatar
    Brysonds
    Helper III
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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.