Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX measure returns wrong total

Hi there   I have a loaded table structured as below,  With this measure I got the visual below (Demand, Supply and Acc.Bal are all directly from the table), and you can see the totals at di...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Try measure like

     

    ACC.BO_CNY = SUMX(Summarize(FCST_BD12, FCST_BD12[Entiy], FCST_BD12[BU], FCST_BD12[Material],"_1",MAX(FCST_BD12[Balance])*MAX(ASP[ASP_CNY])),[_1])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Try measure like

 

ACC.BO_CNY = SUMX(Summarize(FCST_BD12, FCST_BD12[Entiy], FCST_BD12[BU], FCST_BD12[Material],"_1",MAX(FCST_BD12[Balance])*MAX(ASP[ASP_CNY])),[_1])

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks Amit.

It still has some problem, but inspiring anyway.