Dax Template AdventureWork

maciektrylowski — Tue, 02 May 2023 14:17:50 GMT

Does anyone know what Dax template is used to explain Allexcept function here:@ https://learn.microsoft.com/en-us/dax/allexcept-function-dax

i can see that some functions use probably the old template.

thanks

Re: Dax Template AdventureWork

Anonymous — Thu, 04 May 2023 06:28:37 GMT

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:

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.