Total Column by category

[NeedHelp755]

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

I need the Total Rowtotal for each category at end of each section.  So, the values in the box next to the Category 1Total. 

The rows section is by calendar[MonthYear]

THis is what I currently have:

RowTotal Total =CALCULATE(

    [Total Count],

        ALLSELECTED(Projects[Location Description])

[Anonymous · Accepted solution]

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.

[Greg_Deckler]

@NeedHelp755 Not sure I fully understand but maybe this? The New Hotness (Custom Matrix Hierarchy) - Microsoft Fabric Community

[NeedHelp755]

@Greg_Deckler I'm fairly new to using DAX and I wouldn't know how to apply that to my situation.