DAX measure returns wrong total

[Anonymous]

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

[Anonymous]

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.

[amitchandak · Accepted solution]

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

Thanks Amit.

It still has some problem, but inspiring anyway.