Forum Discussion
Difference between filter and filter with allexcept
Hi Anonymous,
Below is the result in my test.
ALLEXCEPT removes all context filters in the table except filters that have been applied to the specified columns. Per my understanding, using ALLEXCEPT in your formula makes the calculation work on group level, while the calculation works on the whole table level without ALLEXCEPT. Here is a similar thread for your reference, but its a scenario about measure:
Best regards,
Yuliana Gu
I started using Power BI 3 months ago so I am still learning how to use DAX effectively.
Especially filters they can be pretty confusing. The reason I use it is that it does what I want. I don't know why it works and that's what I am trying to figure out. I was just trying different things and that worked so that's why I use it.
Basically U Purchases is a calculated column that has a counter that increases each time a customer buys the same U 1 product. For example the first time is 1, second 2, thrid 3, etc. If it is not a U 1 product the respective row is left blank.
Unfortunately it is company data so I cannot post them without heavy masking which I don't have the time to do right now.
Community ChampionWell, basically, the FILTER with the ALLEXCEPT is going to essentially wipe out any other filters other than the Title group filter, the column specified in the ALLEXCEPT. But how that actually interacts with the other filters is going to matter on the order DAX applies those filters, which I'm not 100% certain I can answer that. Perhaps marcorusso?