How to filter where two entries must co-exist.

[Anonymous]

Hi there,

I'm trying to add to a visualisation staff with multiple devices. I want to be able to  only staff that have both a mobile phone AND phone extension. The information for whether or not they have that service are all listed as separate entries under a column "Service" and their names under "Staff Name". Hopefully that's enough info otherwise can try an post a sample data set. Thanks

[Nathaniel_C]

Hi @Anonymous 
Please try this:

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[Nathaniel_C · Accepted solution]

Number of Equipment =

var _Staff =PhoneTable[Staff]
var _calc = CALCULATE(COUNTROWS(PhoneTable),FILTER(ALL(PhoneTable),PhoneTable[Staff]=_Staff))

Return If (_calc <>1,"Both","One Only")