Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Text Columns in Tables - Add Option to Total based on COUNT

When creating a table, there should be an option to show the count of records in the total line.

 

For example, if I have a table with the columns:

  • Staff Name
  • Department
  • Salary

While I can already show the SUM() of the salaries in the total line of the report under the "Salary" column, there is not a way for me to show the Staff count in the total line under the Staff Name column.  If I use the COUNT or COUNT_DISDINCT summary functions, if turns these text fields into numbers.

 

We should not have to add a columns of 1's to show a total for the number of records displayed in the table.  Life should be easier.

Status: New