topic Re: How to get percentage of subtotal in a matrix ? in DAX Commands and Tips

How to get percentage of subtotal in a matrix ?

Anonymous — Thu, 13 Mar 2025 10:27:35 GMT

Hello everybody,

In power BI desktop I would like to get the porcentage of subotals for rows and lines.

Here is my matrix :

I have my hours for lines, week day for columns and the count of my tickets as a value, I activate subtotal for columns and lines( in the format parameters of the matrix) and I would like to add one columns and one line(or add the percentage directly with the subttotal column and line) with the percentage for my subtotal compare to the general total. How can I do to add only one column and one line for the subtotal ? thank you

Re: How to get percentage of subtotal in a matrix ?

bhanu_gautam — Thu, 13 Mar 2025 10:34:32 GMT

Anonymous Create measures

TotalTickets = SUM('YourTable'[TicketCount])

SubtotalTickets = SUMX(ALLSELECTED('YourTable'), 'YourTable'[TicketCount])

PercentageOfTotal = DIVIDE([SubtotalTickets], [TotalTickets], 0)

Add the PercentageOfTotal measure to your matrix, and it will display the percentage of each subtotal compared to the total. This approach ensures that you have a dynamic calculation that respects the context of your matrix, showing the correct percentages for both rows and columns

Re: How to get percentage of subtotal in a matrix ?

Deku — Thu, 13 Mar 2025 10:46:47 GMT

Var grandtotal=

Calculate([Measure], Allselected())

Return

If(

( Not Isinscope(table[month]) && isinscope(table[hour])) ||

( Isinscope(table[month]) && not isinscope(table[hour])),

Format(

Divide([Measure], grandTotal),

"#%"

[Measure]

)

Re: How to get percentage of subtotal in a matrix ?

Anonymous — Thu, 13 Mar 2025 10:47:05 GMT

But with those measures I get de percentage for each columns(monday,tuesday etc) and I would like to get the percentage only for subtotal, how can I do that ? thank you in advance

Re: How to get percentage of subtotal in a matrix ?

Anonymous — Thu, 13 Mar 2025 11:23:47 GMT

I get the good result but as the other solutions, I have one column for each days and I want only one column for my total, how can I choose the display of the columns ? thanks

Re: How to get percentage of subtotal in a matrix ?

Deku — Thu, 13 Mar 2025 12:23:15 GMT

Can you share a image of what you want it to look like

Re: How to get percentage of subtotal in a matrix ?

Anonymous — Thu, 13 Mar 2025 14:06:06 GMT

Something like with all sub percentage for the total of axis Y and the same for the the subtotal of axix X

Re: How to get percentage of subtotal in a matrix ?

Deku — Thu, 13 Mar 2025 14:32:14 GMT

You can't do this with native visuals. You'd have to look at Deneb or some other custom visual