Forum Discussion
Remove filter on single table "issue"
Hey Anonymous ,
you are facing the "dreaded one-table solution" that is implicit with the concept of auto exists.
This concept is described in this article https://www.sqlbi.com/articles/understanding-dax-auto-exist/
Consider to create a star schema, meaning create separate tables for each of the columns inside your fact table, except the numeric columns that will be used as measures.
Regards,
Tom
Super UserHey Anonymous ,
you are facing the "dreaded one-table solution" that is implicit with the concept of auto exists.
This concept is described in this article https://www.sqlbi.com/articles/understanding-dax-auto-exist/
Consider to create a star schema, meaning create separate tables for each of the columns inside your fact table, except the numeric columns that will be used as measures.
Regards,
Tom
Thanks Tom,
normally I use dictionary tables, as you're suggesting. I was wondering though why such feature exist, your explanation & article were really helpfull. Thanks again for not only precise but rapid resonse.
To Icey,
the measure and whole example was created as a sandbox. The idea was to drop one filter (hence allexcept() function) and sum over the rest which is <> what you're suggesting. Nevertheless thanks for contribution.