Count IDs with two values

[RandomUserPby]

Hello,

I have a table with two columns, ID and Type, an ID can be associated with multiples Type, like this :

and I want to count IDs where Type = Yellow AND Purple, like this :

I'm a beginner in DAX and I don't know how to do..

Can someone help me please?

[RandomUserPby]

Thanks you !!

[amitchandak · Accepted solution]

@RandomUserPby , Create a new measures =

yellow = countx(filter(Table, table[Type] = "Yellow") , Table[ID])

purpal = countx(filter(Table, table[Type] = "Purpal") , Table[ID])

both = countx(values(Table[ID]), if(not(isblank([yellow])) && not(isblank([purpal ]))  , [ID], blank() ) )