Show no data when no filters are selected

[Anonymous]

I know there are a couple similar questions, but after looking at the solutions, none of them have worked for me. 

I am buildling a report in which you can look someone up and see their fields of interest and fields of expertise. My data is set up with one table containing a list of individuals ('Individuals') and another table with their interests/expertise. Each person may have several interests or expertises, or none at all. 

Individual Key	Individual Name
1001	Bob Johnson
1002	Sam Miller
1003	John Adams

Individual Key	Category	Interest/Expertise
1001	Medicine	Interest
1001	Hotels	Interest
1001	Dogs	Expertise
1001	Cats	Expertise
1002	Lifestyle	Interest
1002	Writing	Expertise

For the actual report, I would like to show a blank table when a member is not selected, and then when a member is selected, it shows their interests and expertise:

I've tried to play around with variations on this measure:

Int-Exp Filt = CALCULATE ( IF ( ISFILTERED ( Individuals[Full Name and ID] ), 1, 0 ), ALLSELECTED ( 'Interests and Expertise'[exa_category] ))

But Power BI doesn't like having multiple values for a measure so I get an error.  I tried the measure with FIRSTNONBLANK() instead of ALLSELECTED which works except it only shows the first non blank value (duh) and not all of the values. 

Does anyone have any ideas for how to show no values when a specifc filter is not selected and then show several values when that filter is selected?

[v-kelly-msft · Accepted solution]

Hi @Anonymous ，

Modify your measure as below:

Int-Exp Filt = IF ( ISFILTERED ( Individuals[Full Name and ID] )=TRUE(),MAX ( 'Interests and Expertise'[exa_category] ),BLANK())

Best Regards,
Kelly

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

[amitchandak]

Refer:

https://community.powerbi.com/t5/Desktop/Show-no-data-in-a-table-until-a-slicer-item-selected/td-p/4...