Dynamic filtering table with no physical relationship

Hi renaudstaessens 

have you managed to solve your issue?

If not, you can create a measure like this:

Measure =
VAR _skills =
    CALCULATETABLE ( VALUES ( demands[skill] ) )
VAR _matchingSkills =
    INTERSECT ( _skills, VALUES ( skills[skill] ) )
RETURN
    IF ( COUNTROWS ( _matchingSkills ) = COUNTROWS ( _skills ), 1, 0 )

and use this measure in the filter pane(setting Measure is 1) of the table visualization of the employees.

I have attached the mock-up file I created to demonstrate.

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

Hi sturlaws  many thanks as your solution is working great and your explanations and examples are perfect !! sorry not to answer quickly ( i was on vacation 😃 )