Show result in table only if it is filtered

[Dmitriy]

I have a table of employers and 3 filters by name, second name and department.

I need to make my table to show results only if any of these filters are being active.

How I can do it?

[v-lili6-msft · Accepted solution]

hi, @Dmitriy

You could use ISFILTERED to create a measure get your requirement.

 if name, second name and department are in your result visual?

If no, you could add a measure like this 

Measure = IF(ISFILTERED('Table'[name])=TRUE()||ISFILTERED('Table'[Second Name])=TRUE()||ISFILTERED('Table'[department])=TRUE(),1,2)

Then drag it into visual level filter and set filter is 1

If yes, you need add a new name, new second name and new department column and use them in visual

and then drag measure into visual level filter and set filter is 1

Result:

beforeafter

Best Regards,

Lin

[Anonymous]

Hi,

Do you know how I can do this where if you only use one of the filters then the other columns stay blank in a table?

My report has a filtering page, and in the report pages I have a 'Selected FIlters' key which should be blank unless a filter has been used. The key is made up of several one column tables, one for each of the filters. I'd like them to only show a result if that field has been used as a filter. All of these fields  are in the same table.

(Courses)

(Qualifications Type)

(Field of Education)

So far I have been able to make all tables blank using ISFILTERED on one of my fields (Courses), but only this filter returns results in the tables. When I use the other filters nothing appears in any of the tables.

I have used the solution in this thread but only the (Courses) tables is blank and the others are now showing all thier data. When I use a filter all of the tables show filtered results, but I want the other tables to remain blank unless used.

Is there a way to do this?

Thanks

[Lily_DS]

hi leishka

I need  same thing , do you find any way to do that please?

[Dmitriy]

great explanation, thank you

[Greg_Deckler]

Should be able to use ISFILTERED: https://docs.microsoft.com/en-us/dax/isfiltered-function-dax