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

[Anonymous]

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!

[dax]

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]

 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]

@MattAllington 

can you please help me with this?

[Anonymous]

@MFelix ,

May be you can help me with this?

[Anonymous]

Can anyone help me with this issue?

@Cmcmahan may be you can help me with this?