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('...
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!