Forum Discussion
Power BI Report mathematics issue
Greetings, I created a report for our Finance department and have had an anamoly point out. The issue arises with this Dax Measure: Mar Rebate = Sum('Brand Partners'[Rebate %])*Sumx('Sales H...
SUMX is an iterator
So 2% of [Mar Rebatable] is not the necessary the same as 2% of SUMX('Sales History',[Mar Rebatable]).
There is a quick way to check this.
Create a new measure Mar Rebatable using SUMX = Sumx('Sales History',[Mar Rebatable])
Then compare Mar Rebatable with Mar Rebatable using SUMX.Consider resolving the problem with
Mar Rebate = Sum('Brand Partners'[Rebate %]) *[Mar Rebatable])/100
A simple mistake, readily corrected....best!
speedrampsSuper User
Thank you fklatecki.