Forum Discussion
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,...
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.