How does the ALLEXCEPT function (DAX) work?

The ALLEXPECT function (DAX) removes all context filters in the table except filters that have been applied to the specified columns.

ALLEXCEPT Formula Syntax

     <table>, <column>[,<column>[,…]]

How do you use the ALLEXCEPT function?

This function is not used by itself, but serves as an intermediate function that can be used to change the set of results over which some other calculation is performed.

Related Blog Posts

Related Support Forum Posts

Understanding DAX Formula
Developing Complex Dax functions

Considerations when using the ALLEXCEPT function

The first argument to the ALLEXCEPT function must be a reference to a base table; all subsequent arguments must be references to base columns. You cannot use table expressions or column expressions with the ALLEXCEPT function.

Related Video Tutorials

Formula examples using the ALLEXCEPT function

=CALCULATE(SUM(ResellerSales_USD[SalesAmount_USD]), ALLEXCEPT(DateTime, DateTime[CalendarYear]))

ALLEXCEPT ( Customer, Customer[City] )

ALLEXCEPT ( Sales, ‘Date’, Customer[City] )

Related DAX Functions

FILTER Function (DAX)

Related Course Modules



To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.