Hello I have this table here (in short because of privacy issue)
The gross margin column does not show the total the same as Excel - Power BI shows $5.9M while Excel shows $5.4M.
I tried using HASONEVALUE but it still does not work:
IT’s been several days and I still can’t fix it. Could you help? Thank you