Forum Discussion

jaswalsarthak's avatar
jaswalsarthak
Frequent Visitor
1 year ago
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('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
Need Help
  • amitchandak's avatar
    amitchandak
    1 year ago

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

     

     

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    1 year ago

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