Countif with Multiple Conditions

[Anonymous]

Hi, Consider a table 

Date	ID	Type
21/09/2022	A	S
21/09/2022	A	B
21/09/2022	B	S
21/09/2022	C	S

Need a measure to calculate the distinct count of ID if there is only Type = S date wise

[Anonymous]

It counts other IDs as well. I need only the Distinct Count of those IDs containing Type = "S" only not other than "S"

[JorgePinho]

Try this:

Count = CALCULATE(DISTINCTCOUNT(Table[ID]), Table[Type] = "S")  

Then put it in a table together with the date field to see by date.

[Anonymous]

For Example:
If the ID has 2 entries containing Type "S" & "B" then it should be excluded from the required distinct count
If the ID has 2 Entries containing Type "S" & "S" then it should be counted