Forum Discussion

sakshikaul's avatar
sakshikaul
Helper III
5 years ago
Solved

dax Error

Following DAX is giving me an error. Please help   GP Yeild KG = var prodA=divide ( CALCULATE(Sum(DBALLSTAT[Profit])),CALCULATE(Sum(DBALLSTAT[ChglWt(KG)]),Group_Logic[Mode_group_3]="AIR")) var pr...
Need Help
  • sakshikaul's avatar
    sakshikaul
    5 years ago

    var prodA= CALCULATE(Sum(DBALLSTAT[Profit])) var ProdA1=CALCULATE(Sum(DBALLSTAT[ChglWt(KG)]))
    var prodB=CALCULATE(Sum(DBALLSTAT[Profit])) var ProdB2=FLOOR(CALCULATE(sum(DBALLSTAT[Tues]) +(sum(DBALLSTAT[CBM])/25)),1)
    var ProdC=CALCULATE(Sum(DBALLSTAT[Profit])) var ProdC2=CALCULATE(Sum(DBALLSTAT[ChglWt(KG)]))
    var ProdD= if (SELECTEDVALUE(Group_Logic[Mode_group_1])="AIR",divide(prodA,ProdA1), if(SELECTEDVALUE(Group_Logic[Mode_group_1])="OCEAN",divide(ProdB,ProdB2),divide(ProdC,ProdC2)))

sakshikaul's avatar
sakshikaul
Helper III
5 years ago

Still getting the error

 

manikumar34's avatar
manikumar34
Solution Sage
5 years ago

sakshikaul , use SELECTEDVALUE instead max 

 

ProdD= if(SELECTEDVALUE([Mode_group_3])="Air",divide(prodA,prodB),Divide(ProdA,ProdC))

 

Regards, 

Manikumar