Need help with measure

[Anonymous]

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. 

[Gordonlilj]

Hi,

Try this

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