Identify Employees with Multiple Certificates using disconnected table slicer

Richard_Halsall , Table 2 and three should be disconnected

measure =
var _tab = Values('Certificate Group'[Certificate Name])
var _cnt = countrows(_tab)
return
Countx( summarize(Filter('Certificates Held', Certificates Held[certificateName] in _tab), 'Certificates Held'[Employeeid], "_actual", distinctcount( Certificates Held[certificateName])), if([_actual] =_cnt, [Employeeid], blank()))

plot this with employee id of table 3 or with 1(If joined with 3)

Hi,

Thanks for the solution amitchandak  provided, your soution is excellent, and i want to offer some more information for user to refer to.

hello Richard_Halsall , based on your description, you can create a relatiohip between youe emplyee table and your Certificates Held table.

Then you can create a meaure.

Flag =
VAR a =
    VALUES ( 'Certificate Group'[Certificate Name] )
VAR b =
    CALCULATE (
        COUNTA ( 'Certificates Held'[Employeeid] ),
        'Certificates Held'[certificateName] IN a
    )
RETURN
    IF (
        ISFILTERED ( 'Certificate Group'[Group Name] ),
        IF ( COUNTROWS ( a ) = b, 1 ),
        1
    )

Then put the measure and id of employee table to the table visual.

Output

Best Regards!

Yolo Zhu

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