Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

How to use OR Operator in dax calculation?

How can I write this statement with OR operator so that if these conditions don't meet then I should get "Product Level"

Product Level for Index = IF(ISBLANK(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level]),"# Exclude",

IF(ISBLANK(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level]),"# Exclude",

IF(ISBLANK(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level]),"# Exclude",

IF(ISBLANK(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster]),"# Exclude",

IF(SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level])="","# Exclude",

IF(SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level])="","# Exclude",

IF(SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level])="","# Exclude",

IF(SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster])="","# Exclude",

IF(SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level])="# Exclude","# Exclude",

IF(SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level])="# Exclude","# Exclude",

IF(SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level])="# Exclude","# Exclude",

IF(SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster])="# Exclude","# Exclude",

IF(SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level])="Exclude","# Exclude",

IF(SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level])="Exclude","# Exclude",

IF(SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level])="Exclude","# Exclude",

IF(SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster])="Exclude","# Exclude",RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level]))))))))))))))))

DAX

if statement

OR function

amitchandak
4 years ago
Anonymous , usage of OR with if was wrong , try like

Product Level for Index Test = IF(ISBLANK(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level]) ||
ISBLANK(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level]) ||
ISBLANK(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level]) ||
ISBLANK(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster]) ||
SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level])="" ||
SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level])="" ||
SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level])=""||
SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster])="" ||
SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level])="# Exclude" ||
SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level])="# Exclude" ||
SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level])="# Exclude" ||
SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster])="# Exclude" ||
SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level])="Exclude" ||
SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level])="Exclude" ||
SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level])="Exclude" ||
SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster])="Exclude","# Exclude",RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level])

If need use switch

Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56

3 Replies

amitchandak
Super User
4 years ago
Anonymous , You can use || operator or OR function

example

IF(ISBLANK(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level] || ISBLANK(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level] , "# Exclude", "Other")

You can keep on adding condition with ||
- Anonymous
  Not applicable
  4 years ago
  Getting this error after changing to the pipe
  
  Product Level for Index Test = IF(ISBLANK(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level] ||
  ISBLANK(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level] ||
  ISBLANK(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level] ||
  ISBLANK(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster] ||
  IF(SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level])="" ||
  IF(SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level])="" ||
  IF(SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level])=""||
  IF(SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster])="" ||
  IF(SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level])="# Exclude" ||
  IF(SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level])="# Exclude" ||
  IF(SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level])="# Exclude" ||
  IF(SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster])="# Exclude" ||
  IF(SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level])="Exclude" ||
  IF(SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level])="Exclude" ||
  IF(SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level])="Exclude" ||
  IF(SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster])="Exclude","# Exclude",RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level])))))))))))))))))
amitchandak
Super User
4 years ago
Anonymous , usage of OR with if was wrong , try like

Product Level for Index Test = IF(ISBLANK(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level]) ||
ISBLANK(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level]) ||
ISBLANK(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level]) ||
ISBLANK(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster]) ||
SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level])="" ||
SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level])="" ||
SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level])=""||
SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster])="" ||
SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level])="# Exclude" ||
SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level])="# Exclude" ||
SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level])="# Exclude" ||
SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster])="# Exclude" ||
SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level])="Exclude" ||
SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level])="Exclude" ||
SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level])="Exclude" ||
SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster])="Exclude","# Exclude",RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level])

If need use switch

Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56

Forum Discussion

How to use OR Operator in dax calculation?

3 Replies

Related content

SQL Operator with multiple destinations

Use Wildcard Operator

MoM calculation

Question mark as operator

Arithmetic Operation Overflow