Ignore filter for table column

[Silvermountain]

Hi all,

I'm trying to make a very simple table-visual with contactpersons and an amount per person. Due to a filter on all the pages, the table doesn't show all persons (regardles of the amount) but only about a third of the available persons.

To visualise it a little bit I'll share 2 screenshots:
1. Number of rows with a contact_id when filter is included

2. Number of rows with a contact_id when filter is temporarily deleted

How can you make a plain table-visual with all results from a specific data-table, ignoring a filter already existing on page or in the report?

Any help is greatly appreciated!

[vicky_ · Accepted solution]

If it's a slicer that's filtering the data, then you can disable visual interactions

Otherwise, if you're using something in the filter pane, you'll need to change the dax calculations with the REMOVEFILTER() function.