Introducing the DISTINCTSUM and DISTINCTAVERAGE DAX-Like Expressions

Introducing the DISTINCTSUM and DISTINCTAVERAGE DAX-Like Expressions

Appanzee is proud to introduce a couple of the most requested DAX functions: DISTINCTSUM and DISTINCTAVERAGE.

They work much like their DISTINCTCOUNT cousin, with an additional parameter to identify the “column” or field being summed, or averaged:

DISTINCTSUM(<field-id (distinct)>, <field-id (to sum)>, <dax-expression>)

Adds all the numbers for the specified field for the specified distinct field.

DISTINCTAVERAGE(<field-id (distinct)>, <field-id (to average)>, <dax-expression>)

Returns the average of all the numbers for the specified field for the specified distinct field.


At Appanzee, we’re super excited about this very cool addition to our family of expressions. By making our expressions more expressive, we are able to add increasingly powerful capabilities to the platform.

You can check out these functions in action with the BudgetEye app to track and visualize your average spending per category of expenses.

Or create your own app and use these functions as you might in a spreadsheet formula.