Forum Discussion
Solved
Row total not adding
Hi All, i have a dax to calcualte Retail margin for each month & its able to calculate correctly, however the total of the row is completely different. RM YTD = DIVIDE([Units In Price]*SUMX...
jaswalsarthak , Mutiplication need to done at row level , check if this possible
RM YTD = DIVIDE(SUMX('RM Data','RM Data'[Value]*[Units In Price]),103)
or
Keep this same
RM YTD = DIVIDE([Units In Price]*SUMX('RM Data','RM Data'[Value]),103)
Change to consider Matrix column field
RM YTD Number = SUMX(BValues('BI Sales'[Month Year]), [RM YTD])
Thanks amitchandak DIVIDE(SUMX('RM Data','RM Data'[Value]*[Units In Price]),103) worked perfectly.