Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

If Statements doesn't give value as expected, skips the code

Hi,

 

I am trying to use the DAX measure and here is my scenario where IF statement gives blank for case 2

 

Case 1:- Material Group LBLTHT or CORSF, Material Type- ZHWA and Base UOM- EA and ROL

Base UOM Highlights = Maxx( material,
IF(Material[Material group]="CORSF" || Material[Material group]="LBLTHT",
IF(Material[Material type]="ZHWA",
IF (Material[Base Unit of Measure]<>"EA" && Material[Base Unit of Measure]<>"ROL",1,2))
 
The above code works fine ( screeshot above) however in the same code if I add the below code it get skipped
 
Case 2: -Material Group LBLTHT , Material Type- ZNBW and Base UOM- EA 
IF(Material[Material group]="LBLTHT",
IF(Material[Material type]="ZNBW",
IF (Material[Base Unit of Measure]<>"EA" ,1,2))

this above code get skipped and it doesn't add 2 ( screesnhot below) for this combination and gives me Blank data.
Any help greatly appreaciated!
Need Help

5 Replies

  • dax's avatar
    dax
    Community Support
    7 years ago

    Hi tejaswidmello,

     

    I test your expression in my environment, it work well , so I am not sure which part cause this problem. You could check whether your measure is correct or whether other factors cause this problem . If possible, could you please inform me more detailed information (such as your data sample or upload your pbix sample)? Then I will help you more correctly.

    Measure 8 = MAXX(Table5,IF(Table5[group]="LBLTHT",
IF(Table5[type]="ZNBW",
IF (Table5[meas]<>"EA" ,1,2))))

    Please do mask sensitive data before uploading.

     

    Best Regards,

    Zoe Zhi

     

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

       Hi Zoe dax 

      Thanks for your reply!

       

      The one you showed works for me until we do not  add the case 1 code in it..  for ex. shown below: ( the below code includes both Case 1 and case 2.) This code won't work for the later part of the code which says material group= LBLTHT, Type- ZNBW and BUOM<> EA. and if it finds this combination it adds blank

       

      I want both these cases in the same measure. 

       

      Can you please help with this? 

       

       

      Base UOM Highlights = Maxx( material,
      IF(Material[Material group]="CORSF" || Material[Material group]="LBLTHT",
      IF(Material[Material type]="ZHWA",
      IF (Material[Base Unit of Measure]<>"EA" && Material[Base Unit of Measure]<>"ROL",1,2)),
      IF(Material[Material group]="LBLTHT",
      IF(Material[Material type]="ZNBW",
      IF (Material[Base Unit of Measure]<>"EA" ,1,2))
       
      Thanks,
      Tejaswi