Forum Discussion
Ignore filter for table column
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!
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.
1 Reply
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.