Hiding secondary table if main table has one value selected

[PowerBITestingG]

I have 2 tables, the main, and secondary

When users click on a row on the first table, I am displaying the related rows in the secondary table.

When there is not one selection I would like the secondary table to be blank

I would think that just using HASONVALUE(Column) as a filter would work, but for some reason its not affecting the filters

Any ideas?

[v-luwang-msft · Accepted solution]

Hi @PowerBITestingG ,

Test like the below:

HasOneFilter = 
    IF(
        HASONEFILTER(table1[Name]),
        VALUES(table1[Needs]), "")

And a similar case refer:

How to: show data in secondary table IF one company is selected in the primary table

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[amitchandak]

@PowerBITestingG , Choose a column from table one which will get filtered or use more and create a measure like below and use that in visual level filter and check value =1

calculate(int(isfiltered(Table[Column])) , allselected())