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...
I tried still when i click on Child visual data it goes blank. i also added screenshot of changed measure and show Interaction of child with parent visual. on child i applied that dax measure.
Could you please provide me the sample data in csv or xlsx
It won't let me attach file so i added sample data in below tables. Thanks
Parent Table
ID Name
1 a 2 b 3 c 4 d 5 e Child Table
ID Name
1 ab 1 cd 1 ef 2 gh 2 ij 3 kl 3 mn 4 op 5 qr Hi Anonymous
Control_child_table = VAR parent_id = MAXX(ALLSELECTED('Parent Table'), 'Parent Table'[ID]) -- Get Parent ID, ignoring Child selection VAR child_id = MAX('Child Table'[ID]) -- Current Child ID RETURN IF( NOT(ISBLANK(parent_id)) && child_id = parent_id, 1, 0 )Hi Akash, i updated with dax you mentioned above now its showing a value (5, qr) even when no row selected in parent view. I think main concern is when i cick id 1 on parent it filter in 2nd view but as soon as i click inside data in child visual it reset back to(5,qr). we need to preserve selected values based on parent view.