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 different level are all wrong with 0.

Looking for help on it. Thanks!   

ACC.BO_CNY = SUMX(VALUES(FCST_BD12[Material]),-MIN(MAX(FCST_BD12[Balance])*MAX(ASP[ASP_CNY]),0))

 

 

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

3 Replies

  • 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thanks in advance for your kind cooperation!

     

    Hope it helps,


    Community Support Team _ Caitlyn

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.