Disable Report Level Filter on a Visual/Table

Coming across this looking for the same answer, was sure it could be done, and have done it. It's a slight misnomer for v-sihou-msft to say it's "not possible to make one visual not respond to a Report Level Filter" because you can use DAX to override the Report filter (rather than trying to "disable" or "not respond" to it). It's a common business req where you need ratio calcs with wider denominators than filter restrictions for example.

Anyway, you create the DAX Measure (can use DAX on your cubes as well as Tabular models) to override the Report or any other filters. In your case:

msr Sales AllSalesmen = CALCULATE(SUM('Dealership Total Sales'[Sales]), ALL('Dealership Total Sales'[Salesman]))

Note the ALL('Dealership Total Sales'[Salesman]) or ALL('<BaseTable>'[Salesman]) ignores any filter on Salesman, ie the Report filter. It's easy to think you need ALL('Dealership Total Sales'[Sales]) when you don't - there's a subtle but big difference.

This method works nicely on my visualisations, which still have the Report level filter applied to everything else. Hopefully will help you and anyone with same basic requirement.

Phil