Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Remove filter on single table "issue"

Hi, I was playing around with filtering on single table and... ended up with some serious doubts about my mental health :D. Need assistance if filtering removal is behaving correctly (and why, if so)...
Need Help
  • TomMartens's avatar
    TomMartens
    6 years ago

    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

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

Why do you create your measure like below? 

MeasureA = CALCULATE ( SUM ( 'Table'[Value] ), ALLEXCEPT ( 'Table', 'Table'[SelectionA] ) )

Why not just like this?

MeasureA = SUM ( 'Table'[Value] )

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.