Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
RobertKuij
Frequent Visitor

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

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. 

 

Untitled22.png

 

How can I create such as filter?

 

 

1 ACCEPTED SOLUTION
hashtag_pete
Helper V
Helper V

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

View solution in original post

5 REPLIES 5
hashtag_pete
Helper V
Helper V

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

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

lbendlin
Super User
Super User

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

lbendlin
Super User
Super User

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

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.