Forum Discussion
Solved
Incorrect Sum Matrix
How is possible the sum shown in matrix to be incorrect. If I calculate the sum in excel it gives me different number. the fields are decimal type as well. The data are columns as well, no measure....
Hi amirghaderi
Try to build measures to get Price and H from Table B.
Price From B = CALCULATE(SUM(B[Price]),FILTER(B,B[Category] in VALUES(A[Category])))H From B = CALCULATE(SUM(B[H]),FILTER(B,B[Category] in VALUES(A[Category])))Result:
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi amirghaderi ,
This should not be possible, Can you possibly send the file or recreate the issue in a sample file?
/ J