How to make one table dependent on one filter, while other tables on the same page should be static.

[Anonymous]

Hello. I have a filter and 2 tables at the same page and both tables are using same values. But I want to make that first table should be dynamics when filter numbers changes, while the second table should not change based on the filter values. 

So the filter shows greater than the values. For example, if I put 50, it shows values greater than 50 for both tables. But I want to see this filter working only for the first table. How can I make that?

[Greg_Deckler · Accepted solution]

@Anonymous You cand use Format | Edit Interactions to disable visuals from filtering other visuals. Also, you can use ALL, ALLEXCEPT and REMOVEFILTERS to change filter context within measures.

[amitchandak · Accepted solution]

@Anonymous , You can switch off interaction for another table.

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

[Greg_Deckler · Accepted solution]

@Anonymous You cand use Format | Edit Interactions to disable visuals from filtering other visuals. Also, you can use ALL, ALLEXCEPT and REMOVEFILTERS to change filter context within measures.