cancel
Showing results for
Search instead for
Did you mean:
Resolver I

## Matrix new measure on column totals

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?

Snip:

1 ACCEPTED SOLUTION
Resolver I

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
2 REPLIES 2
Resolver I

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
Super User

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

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

Power BI Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau User !!

## Helpful resources

Announcements

#### The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

#### Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors