Forum Discussion
Adding a custom total column with condition
Hi, i have created a matrix in power bi and in that matrix I am performing some calcuations. Now I want to have the total of those columns and want to perform calculations on that total column also....
TheoC
Community Champion
Community ChampionHi Anonymous
If you want the count of each record allocated to a category, then use COUNTROWS like this:
Total Count = COUNTROWS ( 'Table'[Column] )
Otherwise, if you want the SUM of the values, then use the following:
Total Sum = SUM ( 'Table'[Column] )
The above is a starting point, but as jaideepnema has flagged, if you want more advanced assistance, you will need to provide a more detailed explanation.
All the best.
Theo