Disable Report Level Filter on a Visual/Table

[djsly]

Is there a way to disable the Report Level Filter on a visual/table?  

For example, say I have a report with 10 tabs and I want to filter my entire report for "Salesman" = "Bob".  However, I have a table called "Dealership Total Sales" which should always display the total dealership sales and ignore the"Salesman" Report Level Filter. 

Is this possible? I am working on a SSAS cube connection so I cannot edit the underlying table/dataset.  

Thanks!

[TickboxPhil]

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

[v-sihou-msft]

@djsly

No, it's not possible to make one visual not respond to a Report Level Filter.

Regards,