Ignore 1 filter, use all others

[ech12]

Hi, I have a bar chart with the following flters: KPI1, KPI2, KP3

In the same tab, I have a table. When I click on the bar chart, the table is filtered by KPI1, KPI2 and KPI3. Instead, I want the table to be filtered only by KPI1 and KPI3 and NOT by KPI3.

What kind of measure should I create, or is there any other way?

Thanks

[ech12]

Hi guys, thanks for your help, however, no matter what kind of measure or DAX code I use, it seems to be overridden by the filters of the other visual, when something is selected from this.

Consider this example:

One bar chart and one table. A bar is selected from the chart and the table adopts those filters. I want the table to adopt all but one of the filters.

[v-sihou-msft]

@ech12

In this scenario, if you want to ignore the selection in KPI3. You can add ALL(Table[KPI3]) in your CALCULATE() function to clear its filter.

Regards,

[Ashish_Mathur]

Hi,

Can you share a file and show the expected result.

[ech12]

I made some sample data

The first picture shows what it looks like without filtering. The second one shows how it works right now and the third show what I want the table to show once a a store has been selected from the graph

[Ashish_Mathur]

Hi,

The third table is what you should get when you select Store1 on image1.  I will need to see the file to figure what is happening.

[Anonymous]

Hi @Ashish_Mathur,

Try this, hope it help your case.

I have 2 filter, just the first (in the left side) effective my table. The second (in the rightside) won't filter my table data.

[ech12]

It's for work so I can't but, I'll provide what I think is a slightly better explanation.

I have 2 visuals on the same tab. The first visual is a graph which shows the performance of a specific KPI for different stores. The second is a table which shows a list of KPIs which measure <100% for all the stores. The issue is that when I click on the graph, the table will filter and show data for the one specific KPI that the graph is using. What I need instead, is when I click on the visual, the table should show all KPIs (not just the one) under <100%, for that one specific store. Basically, I want the table to ignore the filter of the one KPI and use only the store filter. Is this possbile? Can you help?