Row total not adding

[jaswalsarthak]

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('RM Data','RM Data'[Value]),103)

After going through various artcile i wrote the below Dax but still the problem persist.

RM YTD Number = SUMX('BI Sales','BI Sales'[RM YTD])

Can you please provide me a solution

[jaswalsarthak]

Thanks @amitchandak  DIVIDE(SUMX('RM Data','RM Data'[Value]*[Units In Price]),103) worked perfectly.

[amitchandak · Accepted solution]

@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])