Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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...
Need Help
Akash_Varuna's avatar
Akash_Varuna
Super User
1 year ago

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
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.