Forum Discussion
pgenero
2 years agoFrequent Visitor
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...
- 2 years ago
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/
pgenero
2 years agoFrequent Visitor
Could it be related with the auto-exist mechanism? I foun an article from SQLBi related to this.