How to sum the total of lines?

[Anonymous]

Hey guys, 

 I'm trying to use a cohort spreadsheet which have the totals of active members per line. Is there a way to calculate the total of the line? I want to have a new column calculating the sum of lines, as I tried to picture in the print screen below.

Thanks a lot!

[v-yingjl]

Hi @Anonymous ,

Based on your picture, not certain what is your expected result. Whar did the highlight rows and the down arrow in the picture represent?

If you just want to calculate the number of rows under certain conditions, you can try to use Countrows() function; if not, you can share more details about your expected output for further discussion.

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@Anonymous - Yes, but would recommend unpivoting those columns, will make it easier. If you wish to ignore that advice, and that's perfectly fine, you can use MC Aggregations:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Multi-Column-Aggregations-MC-Aggregations/m-p/391698#M129

Or if this is just a column in a table:

New Column = [Column1]+[Column2]+[Column3]...