Dax measure / need help with a 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. 

[BeaBF]

@Anonymous Hi! Try with:

InterventionsWithoutA61A62 =
CALCULATE(
DISTINCTCOUNT('Table'[Column1]),
NOT('Table'[Column2] IN {"A61", "A62"})
)

BBF

[Anonymous]

Hi

Below is my table:

The following DAX might work for you:

Measure 3 = 
var tmp=CALCULATETABLE(VALUES('Table'[Column1]),'Table'[Column2]="A61"||'Table'[Column2]="A62")
var tmp1=CALCULATETABLE(VALUES('Table'[Column1]),NOT('Table'[Column1] in tmp))
return
COUNTROWS(tmp1)

The final output is shown in the  following figure:

Best Regards,

Xianda Tang

If this post helps ,then please consider Accept it as the solution to help the other members find it more quickly.