Matrix Table Column Percentage

[bdehning]

I have the following Matrix Table.  Can I and how would I add a row at the bottom to show the percentage of each column to the table total?  

So I would get 14/2966, 62/2966, etc?

[v-yueyunzh-msft]

Hi , @bdehning 

According to your description, you want to add a row which shows the "Percentage" in the Matrix. Right?

For the Matirx visual , the total is auto generated, in the settings we can't add another row. We can just add the row in the raw data.

Here are the steps you can refer to :

(1)This is my test data:

(2)We can create a blank Query in PowerBI Query Editor and enter :

let
    Source = Sheet1,
    Custom1 = Table.Group(Source, "Type" , {"test",(x)=> List.Sum(x[Value]) /  List.Sum(Sheet1[Value])    } ),
    #"Added Custom" = Table.AddColumn(Custom1, "Custom", each "Percentage"),
    #"Reordered Columns" = Table.ReorderColumns(#"Added Custom",{"Custom", "Type", "test"}),
    #"Renamed Columns" = Table.RenameColumns(#"Reordered Columns",{{"Custom", "Policy Inception Date"}, {"test", "Value"}}) & Sheet1,
    #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Value", type number}})
in
    #"Changed Type"

The result table is as follows:

(3)We apply the data to Power BI Desktop, We can create a measure in Power BI Desktop:

Measure = var _t =FILTER( 'Query1' , 'Query1'[Policy Inception Date] <> "Percentage")
var _total =   SUMX(_t , [Value])
var _percentage = FORMAT( SUM('Query1'[Value]) ,"Percent") 
return
IF(HASONEVALUE(Query1[Policy Inception Date]) , IF(MAX('Query1'[Policy Inception Date])= "Percentage" ,_percentage ,   _total) ,_total)

(4)Then we can put the filed in the new table and the measure on the visual and we will meet your need , the result is as follows:

Best Regards,

Aniya Zhang

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

[PVO3 · Accepted solution]

This is not easily achieveable. Easiest workaround is to just put another visual below it and format it like it appears to be another total row.

Better solution is this.