Forum Discussion
Dynamic filtering table with no physical relationship
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 😃 )
Hi v-xicai thanks or your answer but it seems not to work 🤔...
I created 2 visual tables . the first one (the one that contains skills demand) . the second one which lists the email of the guy that are supposed to have all required skills correponding to a demand. Please note that this second visual doesn't list the skills only the email of the guy (otherwise i can have several lines for one single guy and i don't want to. I added the visual filter the way you mentionned to the 2nd visual ( it's in french but means not blank).
Whatever row i select in the first one ( whatever demand i select ) i always have the 24 same results . so the list of people display do not depend on the skills needed for the demand selected ... Not sure to catch the logic of your measure. could you explain in few words ? ( i don't understand why you are a doing a max...)
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 😃 )
it seems that i wrongly accept my comment to your solution as the solution 😞 . Sorry it is the first time i accept a solution . I also accepted your own but didn't find a way to remove the first approval . Once again many many thanks for your great help!!! i ll check how to give "kudos"