Forum Discussion
Solved
Remove filter from one column
I have created a table called Calculator Power Query that contains 2 fields (M2, M3) containing a series of values from 0 to 95, incrementing by 5. I am using 2 filters in the report: one that...
I've found the reason behind this behaviour and it is related to auto-exist mechanism applied by DAX when there are 2 or more filters operating over the same table.
Refer to this article from sqlbi for better understanding of this: https://www.sqlbi.com/articles/understanding-dax-auto-exist/
ryan_mayu
Super User
Super Userwhat about change the visual interaction and set to no impact?
Please read my post: I can not use the option Edit Interactions between visuals, since my intention is to create another measure based on M3 (that at the same time should avoid M2), and then compare M2 and M3 on the same chart.