Matrix new measure on column totals

[Mike_Mace]

Happy covid days to all,

I have a matrix with info:

1. A list of 25 deliverables with random plan dates & random dates they were submitted

2. I created (head) columns by "starting-date" week. All random dates are grouped in those weeks

3. Each (head) column has three values (sub columns). Two first values (columns) come from data tables, third is a measure

I am looking to show a percentage delivered each week. That is what % of column sum "plan sum"  is "sub sum"

So as per snip, first week would be 80%, 4 of 5

second week would be 60%, 3 of 5

third week would be 40%, 2 of 5

Ideally this would be a new row under the Column Totals. Not confident that is possible (?) 

Is this easier done with new measures on a new matrix?

 

PBI File@ https://we.tl/t-LgfRsAnKLS

Snip:

[Mike_Mace · Accepted solution]

Hi @amitchandak 

Thanks you got me thinking outside the matrix.

No they were columns. Solution:

DIVIDE(SUM('submission date'[sub sum]),SUM('plan date'[plan sum])) * 100

[amitchandak]

@Mike_Mace , If these are two measures? you can get like

divide([sub sum],[plan sum])