Amazon QuickSight
User Guide

The AWS Documentation website is getting a new look!
Try it now and let us know what you think. Switch to the new look >>

You can return to the original look by selecting English in the language selector above.


Based on a conditional statement, the maxIf function returns the maximum value of the specified measure, grouped by the chosen dimension or dimensions. For example, maxIf(ProdRev,CalendarDay >= ${BasePeriodStartDate} AND CalendarDay <= ${BasePeriodEndDate} AND SourcingType <> 'Indirect') returns the maximum sales goals grouped by the (optional) chosen dimension, provided the condition evaluates to true.


maxIf(measure, condition)



The argument must be a measure. Null values are omitted from the results. Literal values don't work. The argument must be a field.


One or more conditions in a single statement.

On this page: