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!
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.
Solution SageThis 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!
I have created a different distinct values table for Month+Year, and used ALL( Table2[Month+Year]) in CALCULATE function. Still doesn't work for me! any other solution I can try out?
Thanks alot for that info, that solved my problem! Star Schemas ftw.