Forum Discussion
Strange result for ALLEXCEPT
This is due to the different granularities within your one-table model and the order in which you use its fields in the visuals (see: https://www.sqlbi.com/articles/using-allexcept-versus-all-and-values/ )
I recommend start build a proper star-schema for your data in order to use ALLSELECTED : https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/
This should explain why one-table-models are a road to disaster in Power BI.
This is due to the different granularities within your one-table model and the order in which you use its fields in the visuals (see: https://www.sqlbi.com/articles/using-allexcept-versus-all-and-values/ )
I recommend start build a proper star-schema for your data in order to use ALLSELECTED : https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/
This should explain why one-table-models are a road to disaster in Power BI.