MAXA Function (DAX)

How does the MAXA function (DAX) work?

The MAXA function (DAX) returns the greatest value in a column. Does not ignore logical values and text.

MAXA Formula Syntax


How do you use the MAXA function?

The MAXA function corresponds to MAX used as argument for all data types except for Boolean with a single column. When operating with a Boolean data type, MAXA considers TRUE to be 1 and FALSE to be 0.

The MAXA function executes MAXX internally for arguments which are not boolean, without any difference in performance.

Related Blog Posts


Considerations when using the MAXA function

Empty cells are ignored. If no values can be used in the column, then MAXA returns 0 (zero).

If the text values are to be compared, use the MAX function.

Related Video Tutorials

Ultimate Beginners Guide to DAX

Formula examples using the MAXA function


= MAXA (


Related DAX Functions


Related Course Modules