Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

4 Replies

  • jaideepnema's avatar
    jaideepnema
    Solution Sage
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

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

  • TheoC's avatar
    TheoC
    Community Champion
    4 years ago

    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

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Community Support
    4 years ago

    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.