Help with multiple OR operations selected from one data field.

[tbobolz]

Excel 2010 V1


Hi All,
I hope you can help me with this. I have the following formula with works fine; however, I wish to add two more values to my "OR" statment in this formula. Of course DAX only allows 2 arguments in a OR operation. How could I write this statement to include all 4 values: of XFRHOSPICE, XFROTH, XFRPSY and XFRSNF.

Currently I can only get these two included in the "OR" statement, XFRHOSPICE, XFROTH. Is there a way to nest an IF, OR or AND statement or maybe a completely different way to write this that I am missing?

=CALCULATE([Cases], 'EPSI SOAR MNDOG'[DISCHARGE - FISCAL YEAR]=2014, 'EPSI SOAR MNDOG'[ED FLAG]="NON ED", 'EPSI SOAR MNDOG'[TRAUMA LOG]="", or('EPSI SOAR MNDOG'[ADMISSION SOURCE]="XFRHOSPICE", 'EPSI SOAR MNDOG'[ADMISSION SOURCE]="XFROTH"))


Thanks for any help you can offer.

Terry

 

[Norah]

Instead of using "OR", you can use "||" between the items. It means the same thing, but doesn't carry the limit of two items. (The same goes for "AND" - you can use "&&".)

Your measure would look like this:
=CALCULATE(

[Cases],​

'EPSI SOAR MNDOG'[DISCHARGE - FISCAL YEAR]=2014,
'EPSI SOAR MNDOG'[ED FLAG]="NON ED",
'EPSI SOAR MNDOG'[TRAUMA LOG]="",
(​

'EPSI SOAR MNDOG'[ADMISSION SOURCE]="XFRHOSPICE" ||
'EPSI SOAR MNDOG'[ADMISSION SOURCE]="XFROTH" ||
'EPSI SOAR MNDOG'[ADMISSION SOURCE]="XFRPSY" ||
'EPSI SOAR MNDOG'[ADMISSION SOURCE]="XFRSNF"​

)​

)

 

[tbobolz]

Thank you for the lesson Norah, you have changed my life, this works great! I did get it to work with a nested if statement within the data; however, this is much cleaner!

Terry