Identify Employees with Multiple Certificates using disconnected table slicer

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 your 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.