Home » POWER BI » Page 6


Power BI is a business analytics service by Microsoft. It provides interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.

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.

 1,515 total views,  4 views today