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
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
Hi @v-karpurapud,
I need to incorporate the Accessories category and Total Smartphone Units into a single formula:
Accessories Attached Rate% = Accessories Units / Total Smartphone Units
Since they cannot be used separately in different visuals, I am looking for a solution to achieve this.Could you please advise if there is a way to implement this?
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