Dax Template AdventureWork

Hi maciektrylowski ,

 

As far as I know, ALLEXCEPT() function will return a table with all filters removed except for the filters on the specified columns.

Here I create a sample to help you understand the function.

You can compare below measures which are created by ALL/ALLEXCEPT/ALLSELECTED. They will return similar results in my sample.

ALLEXCEPT = 
CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[Region]))

ALL = 
CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),'Table'[Region] = MAX('Table'[Region])))

ALLSELECTED = CALCULATE(SUM('Table'[Value]),ALLSELECTED('Table'[Category]))

Result is as below.

The logic of above measures are all suming based on region group.

You can refer to below blog to learn more details.

For reference:

Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.