SUM column

[Anonymous]

Hi there,

I am trying to sum a column with DAX in Power BI. The column which I am trying to sum has numbers in it. I want to sum the rows as a quantity so it shows the number of rows instead of adding the values of the rows. Am I using the incorrect DAX function?

[d_gosbell · Accepted solution]

Yes, you are using the wrong function. If you want a count of rows the best function to use is probably COUNTROWS( <table> )