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

[RobertKuij]

Dear Members, 

I am encountering a small challenge in my PowerBI dasboard. I am creating a dashboard with the search profiles of companies. There is one specific text field called 'Need' (see bottom right of the dashboard). This is written text with additional info about a company's search criteria. 

Now I would like to create a filter to only show the company's need (bottom right in the dashboard IF only one company from the primary table is selected (large table on the left/middle. 

How can I create such as filter?

[hashtag_pete · Accepted solution]

Hello Robert, 

for example like this: 

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

in Tabelle1[CompanyName] you look if there is a filter on this, in VALUES(Tabelle1[Needs]) you give the column that needs to be returned when the company name is filtered. 
If nothing is selected, return empty. 

Does that help?

best

hashtag_pete

[RobertKuij]

Great, this works perfectly fine! Thank you very much for the help!

[lbendlin]

Please provide sample data in usable format (not as a picture) and show the expected outcome.

[lbendlin]

Have you looked into functions like HASONEVALUE() or HASONEFILTER() ?

[RobertKuij]

I have no clue how I should type the measure, to be honest.