Adding % of Total Column in Matrix When Using a Field That Is Grouped by Columns

[cmadson]

Hello all,

I currently have a matrix visualization that I am creating in PowerBI to replicate an excel report. Based on what you can see below, the matrix uses a colum with date group labels (a column already supplied in the excel raw data reference table) called "Age First Close Group". What I am trying to do is add an additional column that provides a % of the total column that are represented in the 30 Days column. In Excel I would just use a simple formula to divide the value in the 30 Days column by the Total Column for each row and express as a %. I am at a loss as to how I can replicate this in PowerBI. 

Thanks in advance!

[v-xiaotang]

Hi @cmadson 

Thanks for reaching out to us.

please share the expected output, also check if this link helps, https://funbiworld.com/2018-04-20-How-to-Get-Perctage-of-Total-in-Matrix/

Best Regards,

Community Support Team _Tang

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