Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

DAX Help

Hi all, I have below condition IIf([Q_12_MO]=0 And [Q_THRU_TON]=0,"Not Shipping", IIf([PCTONPGM]="No Assemblies Shipped","Outside Tolerance", IIf([PCTONPGM]<90 Or [PCTONPGM]>110,"Outside...
Need Help
Show and Tell
JoBI's avatar
JoBI
Resolver II
2 years ago

Hello, as PCTONPGM is in text format you can not compare it with number.

You can try the following:

Result_ = IF(
  [Not Shipping Cond]= "1",
  "Not Shipping",
  IF(
    [PCT ON PGM] == "No Assemblies Shipped",
    "Outside Tolerance",
    IF(
      VALUE([PCT ON PGM]) < 90 || VALUE([PCT ON PGM]) > 110,
      "Outside Tolerance",
      "Acceptable"
    )
  )
)

 

Hope this helps