## Content with tag sum()

Items 1 to 6 of 6

### Stairway to DAX and Power BI - Level 12: Function / Iterator Function Pairs: The DAX CountA() and CountAX() Functions

Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX CountA() and CountAX() functions, discussing the syntax, uses and operation of each. He then provides hands-on exposure to CountA() and CountAX(), in counting non-empty cells in a column, and in counting nonblank results when evaluating the result of an expression over a table, respectively.  Read more...
By Bill Pearson 2017/11/29 | Source: SQLServerCentral.com | Category: dax
Rating: (not yet rated) |  Discuss |   Briefcase | 417 reads

### Curious Case of SUM Function

How a simple SUM statement could change an output.  Read more...
By Utsav Verma 2017/08/24 | Source: SQLServerCentral.com | Category: sum()
Rating: |  Discuss |   Briefcase | 1,917 reads

### Type INT

By Lesole Sebego 2016/11/18 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,370 reads

### Round averages

By Steve Jones 2016/09/29 | Category: aggregates
Rating: (not yet rated) |  Discuss |   Briefcase | 1,359 reads

### Stairway to DAX and Power BI - Level 6: The DAX SUM() and SUMX() Functions

Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson exposes the DAX SUM() and SUMX() functions, comparing and contrasting the two. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in managing “sum” aggregations within our PowerPivot model designs.  Read more...
By Bill Pearson 2014/12/24 (first published: 2014/08/27) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,303 reads

### Stairway to DAX and Power BI - Level 6: The DAX SUM() and SUMX() Functions

Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson exposes the DAX SUM() and SUMX() functions, comparing and contrasting the two. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in managing “sum” aggregations within our PowerPivot model designs.  Read more...
By Bill Pearson 2014/12/24 (first published: 2014/08/27) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,303 reads
Items 1 to 6 of 6

Tags
 aggregates (3) t-sql (3) dax (2) power bi (2) calculation (1) card (1) column (1) count() (1) counta() (1) countax() (1) datatype (1) decimal (1) delimited (1) filter (1) formula (1) function (1) matrix (1) measure (1) numeric (1) pivottable (1) power bi desktop (1) powerpivot (1) productx (1) report (1) round() (1) slicer (1) stairway series (1) string (1) sumx() (1) visualization (1)