Skip to content
Home » DAX » Page 3

DAX

Power BI DAX: Data Analysis Expression (DAX), According to Microsoft Documentation DAX is a collection of functions, operators, and constants that can be used in a formula, or expression, to calculate and return one or more values. Stated more simply, DAX helps you create new information from data already in your model.

SUMX Function DAX

SUMX() is a power bi DAX  Math function that returns the sum of an expression evaluated for each row in a table. It returns a decimal number. 

It goes through a table, row by row to complete the evaluation after filter is applied.

Only the numbers in the column are counted. Blanks, logical values, and text are ignored.

It can be used to evaluate expression over multiple columns as it has the ability to work row by row.

 2,547 total views