Forum Discussion
ALL() does not remove filter
Hi jdusek92
This confusing behaviour is due to auto-exist.
Check out this article:
https://www.sqlbi.com/articles/understanding-dax-auto-exist/
The solution in this case is to create dimension tables for columns you are filtering on: Potential Rating and Job Level.regards
Hi, thanks for your reply.
I submitted an idea to change this behavior to be less confusing and more friendly towards non professionals who do not know what a "star schema" is.
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=3f6ad02e-eb2a-ee11-a81c-000d3a0ec312
Hi jdusek92
This confusing behaviour is due to auto-exist.
Check out this article:
https://www.sqlbi.com/articles/understanding-dax-auto-exist/
The solution in this case is to create dimension tables for columns you are filtering on: Potential Rating and Job Level.
regards
Hello OwenAuger
thanks for the article, it indeed explains the behavior.
I would like to ask some more:
- Is there some workaround/DAX syntax to make this work with only one flat table? often I create just a quick small reports, so I think for these scenarios it is an unnecessary struggle to create a dimension table for all the filters I might use. Is there some syntax that can make it work on the original data model?
- Does Auto-Exist cause problems only with ALL and REMOVEFILTERS, or are there some some other DAX functions where I should be aware of this problems with single talbe models?