Forum Discussion
ALL function doesn't delete filter
NEVER use a single-table models. NEVER. They work counterintuitively and many a time will return wrong numbers without you even knowing it. Always use a proper star schema. ALWAYS.
Ignoring the above will result in you creating completely unreliable models that will calculate things you won't even be able to explain.
Understand star schema and the importance for Power BI - Power BI | Microsoft Docs
If you want to know what can happen if you don't follow the advice, here's an example: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Why-one-table-models-will-produce-WRONG-NUMBERS/td-p/1904161
NEVER use a single-table models. NEVER. They work counterintuitively and many a time will return wrong numbers without you even knowing it. Always use a proper star schema. ALWAYS.
Ignoring the above will result in you creating completely unreliable models that will calculate things you won't even be able to explain.
Understand star schema and the importance for Power BI - Power BI | Microsoft Docs
If you want to know what can happen if you don't follow the advice, here's an example: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Why-one-table-models-will-produce-WRONG-NUMBERS/td-p/1904161