Forum Discussion
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 points to column M2, and one that points to column M3.
I want to filter M2 and with a measure get the maximum value of that filter, avoiding all the filters that may be in M3.
The problem is that I can't avoid filtering M3. Check this image, my metric should return 55, but it is returning 45 (the maximum value in M3):
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.
Here is my metric:
If I use an ALL (Calcultaor), that returns the maximum value in the column. I've tried with other combinations of ALL/ALLEXCEPT/ALLSELECTED but no luck.
I do not realize what I'm doing wrong.
Thanks!
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/
4 Replies
what 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.
Could it be related with the auto-exist mechanism? I foun an article from SQLBi related to this.
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/
