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
- That's a great question, and I'm afraid I can't find a workaround (so far). I'll keep trying though. Someone else may be able to suggest something! Since it all relates to how the DAX query handles filters from columns of the same table, it's not an easy one 😞
- This is the main issue that I'm aware of in terms of DAX calculations, but there could well be others.
If you connect Excel and generate the same outputs (with an appropriate PivotTable or cube function and slicers), you end up with the result you expected. I guess this is a "benefit" of the MDX queries generated by Excel.
I will have a further play around and see if I can add anything else.
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