Forum Discussion
Helper IIHave a Visual not impacted by the page level filter
Interactions only work with the slicers as off now. Not with filter pane. Better you have a slicer and use Interactions.
You can also explore these options
https://prologika.com/overwriting-power-bi-filters/
https://community.powerbi.com/t5/Desktop/A-Measure-That-Ignores-Page-Level-Filters/td-p/573128
https://community.powerbi.com/t5/Desktop/DAX-formula-to-ignore-page-filter/td-p/366501
Community ChampionAlexGurovich - So this is going to depend on where your issue lies. If the filter is impacting a value that you do not want impacted, then you are going to write a measure that utilizes ALL, ALLEXCEPT or REMOVEFILTERS in order to remove the page level filter from the calculation.
Now, if your filter impacts something like an x-axis, for example, then you are going to want to create a table for that x-axis. You would do this by creating a new table using something like DISTINCT on the column used in that x-axis. Once you have that table, you create a relationship between the two tables and then a similar kind of measure.
Easier to explain with a PBIX, which is attached. Let me know if there is a circumstance that this does not cover.
You need to add visual level filter for all else you can create seperate page for which you don't want filter.
Thanks
Pravin