Forum Discussion
Make measure ignore specific filter
This is not really an issue. It is clearly explained in this article from Alberto. It is happening because of Auto Exist feature in DAX.
Besides, creating a seperate dimension table is not really a workaround, but rather a best practice. A Star Schema is always considered best when working with Power BI Datamodel. This is what makes it more powerful!
Hey guys!
It's dead simple, really. Use the ALL function to remove a filter on a specific column like this:
Measure = calculate(Expression,ALL(column-you-want-to-remove-filter))
That's it. ALL, used inside a CALCULATE expression, works like REMOVEFILTER.
Helper IYes, confirmed. It works with Calculate([expression],ALL([column name])).
I see a lot of responses that it works with ALL, but no one adresses the specifik problem/bug in my example (download file below to see my example). There I illustrate that in some cases it won't work.
- AkhilAshok
Solution Sage
This is not really an issue. It is clearly explained in this article from Alberto. It is happening because of Auto Exist feature in DAX.
Besides, creating a seperate dimension table is not really a workaround, but rather a best practice. A Star Schema is always considered best when working with Power BI Datamodel. This is what makes it more powerful!
- Thank you! Finally someone cares to understand the problem thoroughly and not just throws out a guess!