How to get percentage of subtotal in a matrix ?

[Anonymous]

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

[Anonymous]

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

[Deku]

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]

)

[Anonymous]

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

[Deku]

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

[Anonymous]

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

[Deku · Accepted solution]

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

[bhanu_gautam]

@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