Show % of Total on a Matrix SubTotal column

[niallhannon]

I have a matrix control with two column settings, a "Half Year" and a "Month".

H1                                                         H2

Jan, Feb, Mar, Apr, May, Jun, Total       Jul, Aug, Sep, Oct, Nov, Dec, Total

Is it possible to show a "% of Total" value beside the Half Year totals without showing them against each month?

i.e.

H1                                                                           H2

Jan, Feb, Mar, Apr, May, Jun, Total, % of Total       Jul, Aug, Sep, Oct, Nov, Dec, Total, % of Total

[AnthonyTilley]

% of Total = 
Var t = CALCULATE(sum('Table'[AMT]),ALL('Table'))
var h = sum('Table'[AMT])
var tp = DIVIDE(h,t)*100
Var ret = IF(not(HASONEVALUE('Table'[Month])),tp,BLANK())
return ret

in the matrix values formating tick show on rows

[niallhannon]

Hi, Thanks that is nearly it but as I already have multiple rows of data on the matrix is there any way of showing the "% of total" as a column just to the right of the "Total" column? Thanks

[v-piga-msft · Accepted solution]

Hi @niallhannon ,

I'm afraid that you need to create a measure for % total and then drag it to value field in matrix.

However, it will show like this if you have two values under value fields.

Best  Regards,

Cherry

[Greg_Deckler]

If you can provide some sample data it would greatly help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490