Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Need help with measure

Hi everyone,

I would like to do this measure : 

calculate the number of interventions using the distinctcount function for which there is neither the "A61" nor the "A62" intervention. Here is the table. Table name: Table. 

  

Thank you, My best regards. 

Need Help
Tips and Tricks

1 Reply

  • Gordonlilj's avatar
    Gordonlilj
    Icon for Solution Sage rankSolution Sage
    7 years ago

    Hi,

     

    Try this

    Measure = CALCULATE(DISTINCTCOUNT(Table[Column]),FILTER(Table,Table[Column2] <> "A61" && Table[Column2] <> "A62"))