cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Usinghal
Helper I
Helper I

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

So can you please suggest how can i acheive that

 

4 REPLIES 4
v-angzheng-msft
Community Support
Community Support

Hi, @Usinghal 

 

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
Memorable Member
Memorable Member

Hi @Usinghal 

 

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

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?  www.linkedin.com/in/theoconias

jaideepnema
Super User
Super User

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

@ jaideepnema

Usinghal_0-1635745803344.png

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.

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors