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

amitchandak's avatar
amitchandak
Super User
5 years ago

sakshikaul , You have to change var ProdD like this and try

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

  • sakshikaul's avatar
    sakshikaul
    Helper III
    5 years ago

    Still getting the error

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hisakshikaul， 

       

      According to the image you provided, the highlighted section needs to be re-referenced, and not referencing the column correctly is causing this error.

       

      Hope it helps.

       

      Best Regards,
      Caitlyn Yan

       

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

      • sakshikaul's avatar
        sakshikaul
        Helper III
        5 years ago

        Hi,

        I have referenced to a column name but still not getting the output . 

        When I am Selecting filter Mode as AIR. I am getting the output but when selecting Mode = OCEAN then I am getting blank values

        when Filter Mode=AIR

         

    • 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