Adding a custom total column with condition

[Anonymous]

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..

So can you please suggest how can i acheive that

[v-angzheng-msft]

Hi, @Anonymous 

Still not very clear for me, how the percentage column mentioned above is calculated to get?
Are you already getting the percentages for each category individually, and you want to get the percentages for all categories in total?

If we know exactly what you are trying to achieve, you might be able to get a solution faster.

As a general advise, please, provide:

1. Sample (dummy dataset) data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,
Community Support Team _ Zeon Zheng

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

[TheoC]

Hi @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

[jaideepnema]

Hi @Anonymous ,
Not clear, can you share a sample pbix with sensitive data removed along with the expected output so that we can check your query ?

[Anonymous]

@ jaideepnema

Here as you can see I am calculating % for every row, now what I want is to calculate the total of each column and calculate the percentage for that total one.