Forum Discussion
Helper IIICount from summarizecolumns
sovereignauto With the table summarized, counting the count column is the same as counting the rows in the table so you can use COUNTROWS. You could also use COUNTX or any of the other X aggregation functions if you wanted to be specific about the column or wanted an aggregation like sum, SUMX(_data,[count]).
Community Championsovereignauto With the table summarized, counting the count column is the same as counting the rows in the table so you can use COUNTROWS. You could also use COUNTX or any of the other X aggregation functions if you wanted to be specific about the column or wanted an aggregation like sum, SUMX(_data,[count]).
Helper IIIah so simple! i was having a moment and was just trying count() rather than countx!
ended up using count rows as per your advice!
thank you!