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