Forum Discussion
Two 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.
Heya,
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.
This did put me in a good direction, but is there a way to NOT list ALL the comments in the second table when there is NOTHING selected in the first table? When the report is first opened, there is nothing selected in the primary table and it shows all comments made in the second table, which is confusing.