Only showing data in a second table when a single row is selected in first table

[wilson_smyth]

I have a list of contacts who attended events. I can see a table of the most recent event they attended.

Each contact can be a part of one or more office. Offices are shown in a second table.
I only want to show the offices in the second table, when a single contact ( or row in the first table) is selected.

As i have no measures on the tables and am not aggregating, im unsure how to tackle this.

The below link is to a sample pbix illustrating the issue, . I want to only see the offices in the Contacts Office table, when a user selects a single contct row in the attendance table.

Link to pbix

Appreciate any advice on this.

[v-jiascu-msft]

Hi @wilson_smyth,

There could be a workaround. But I can't do it in your mode. It's something like this: adding a tag column.

tag =
IF (
    ISFILTERED ( Office[Office Name] ),
    COUNT ( Contact[Contactname] ),
    BLANK ()
)

Please create an idea here for the new feature.

Best Regards,

Dale

[vanessafvg]

@wilson_smyth if i click a row in the table with contact name it shows only the office selected, so dont understand what your issue is exactly?  maybe screen shot and show the problem

[wilson_smyth]

Apologies, I did not ask the question correctly.

Currently, if no rows are selected, all offices are displayed in the offices table.

I want 0 rows to show in the offices table, unless a row is selected in the contacts & events table. 

[Gazzer]

I don't believe what you want is currently possible.

Maybe it would be worth suggesting as an update?
I would vote for the idea...