Create a Measure: Where a value equals one value or another value

[AW1976NOVA]

I'm trying to build upon an existing measure I've already created.

Here is my current formula:

Cervical Cancer Participating 1 = (CALCULATE(DISTINCTCOUNT('Claim Data Pull'[Member ID]), FILTER('Claim Data Pull','Claim Data Pull'[Gender]="Female"),'Claim Data Pull'[Age]>=21,'Claim Data Pull'[Age]<=65,'claim data pull'[Dx 1]="Z01.411"))

My problem is, I'd like to build on to this formula where 'Claim Data Pull'[Dx1] can equal any of the following results:

Z01.411 or Z00.01 or Z11.51 or Z00.00 or Z12.4 or Z01.419

My problem is, I don't believe there is OR functionality within DAX.  I've tried just adding an additional (Calculate(DistinctCount( ... with each instance ... but that creates duplicates so that isn't an option either.

Any ideas?

[vanessafvg]

or is || in dax. 

https://dax.guide/op/or/

[Anonymous · Accepted solution]

Hi, Try below measure

Cervical Cancer Participating 1 = (CALCULATE(DISTINCTCOUNT('Claim Data Pull'[Member ID]), FILTER('Claim Data Pull','Claim Data Pull'[Gender]="Female"),'Claim Data Pull'[Age]>=21,'Claim Data Pull'[Age]<=65,'claim data pull'[Dx 1] IN {"Z01.411", "Z00.01","Z11.51","Z00.00","Z12.4","Z01.419"}))

Did I answer your question? Mark my answer as a solution!