Dynamically show data in table when another visualisation is selected

[Anonymous]

I have a pie chart showing total income based on three different platforms. 

You can then break the platform down to database, so underneath the pie I have a table showing database and total income.

So when you select one platform from the pie, the table below will show all the relevant databases for that platform. 

When you haven't selected a platform, the table below shows all databases. 

I want the table to be blank until someone selects a platform. 

Is this possible at all? I have a feeling no, but thought I would ask. 

[AnthonyTilley · Accepted solution]

you can use the hasonefilter function and then rplace with blank if not true 

in the code below replace sum('Table'[amt]) with the measure you are showing in your table 

measure = if(HASONEFILTER('Table'[platform]),sum('Table'[amt]),BLANK())

[Anonymous]

Hurrah, this works @AnthonyTilley thanks so much! Sorry for the delay have been off work for a week but this is super 🙂