Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

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?

 

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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!

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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!