Forum Discussion
: Issue with ALLEXCEPT Function in Power BI – Unexpected Filtering Behavior
Hi Praj8050
Unfortunately, there's no other way to implement this. The issue comes from how filters and contexts are managed when multiple dates are selected. The total number of smartphone units changes based on the filter selection. When you select multiple dates, the total smartphone units change because different accessories are added for each specific date. This is why the total changes.
If you find this post helpful, please mark it as an "Accept as Solution" and give a KUDOS.
Hi Praj8050
Unfortunately, there's no other way to implement this. The issue comes from how filters and contexts are managed when multiple dates are selected. The total number of smartphone units changes based on the filter selection. When you select multiple dates, the total smartphone units change because different accessories are added for each specific date. This is why the total changes.
If you find this post helpful, please mark it as an "Accept as Solution" and give a KUDOS.
This issue is causing lot of formulas to breakdown. Is there a way to fix this or any other alternative solution
I don't understand why the ALLEXCEPT function breaks only when multiple filters are applied. According to the documentation, it should handle this scenario. Is this a bug or a limitation of the ALLEXCEPT function