Forum Discussion
interation between 2 visual to filter data
Hi Guys, I got 2 table visual from 2 different tables. I'm trying to filter 1st visual(master) (on click) to filter 2nd visual(child). And i want to click on 2nd visual returned rows without impacti...
Anonymous Hello Mel,
Can you please try below measure?
control_child_table =
VAR _id = SELECTEDVALUE('contact_master'[id])
VAR _fil_id = FILTER('contact_child', 'contact_child'[id] = _id)
VAR _condition = IF(COUNTROWS(_fil_id) > 0, 1, 0)
RETURN IF(_condition = 1, 1, 0)
Thanks
Harish M
Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Hi Harish, thanks for you reply i tried this dax on child visual but when i click on child filtered rows it reset and show all the records. i'm using below relation in tables. thanks