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 ...
Need Help
dax's avatar
dax
Icon for Community Support rankCommunity 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
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

       

      MattAllington 

       

      can you please help me with this?

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        MFelix ,

         

        May be you can help me with this?