Forum Discussion
Helper IITwo related tables - hide second table list until primary record selected
That's indeed a strange behavior. What I tested so far is:
1. if the columns are in the same table the behavior is what you described
2. if you do the suggested solution between two related tables then it works properly (completely hiding table 2 if nothing is selected in table 1)
Try creating a new table, only with the unique ProjectIDs, create a relationship with your Table1, create the Selected measure based on the new table and do the the rest.
Solution SageHeya,
I may misunderstand your scenario but I'm thinking a measure based on Table 1 which you can use as a filter (in the Filter Panel) for Table 2.
The measure would be somethign like:
Selected = IF(NOT ISBLANK(SELECTEDVALUE('Table1'[ProjectID])),1,0)
You then put this measure as a filter in Filter panel for table 2 and set it to show when 1 (see below):
Hope it helps.
Helper IIThank you!!! I originally put the measure in the first table and moved it into the second (not sure if that mattered) and made sure my syntax was correct. But now it is working as expected. Have a great day!