Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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())
Solved! Go to Solution.
Thanks for effort, solution to problem is at this link Final Word On Measure Totals.
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?
Check columns named 13_TI_Total Payments Received and 12_Upsale_Total Payments Received. This is where error shows.
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.
Thanks for effort, solution to problem is at this link Final Word On Measure Totals.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |