Forum Discussion

NeedHelp755's avatar
NeedHelp755
New Member
2 years ago
Solved

Total Column by category

In the Power BI matrix.  I have two sum counts for categories (Category 1 Totals & Category 2 Totals).  Since I have the grand total for rows "ON", the total for each category is placed at the end of...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi NeedHelp755 

    Based on your needs, I have created the following table.



    You only need to make simple changes to the structure of your matrix to see the individual totals for each category and the totals for all categories according to your needs.


    Result:



    If the above methods do not solve your problem, please provide sample data that fully covers your issue and the expected outcome based on the sample data you provided.

     

     

     

     

     

     

     

     

     

     

    Best Regards,

    Jayleny

     

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