Sum by distinct period

[matal4]

Hello,

I have the following dataset, where column "No of transactions per co-worker" is just simply "Transactions" divided by "Co-workers":

Period	Team	Transactions	Co-workers	No of transactions per co-worker
Sep-17	Team A	800	10	80
Sep-17	Team B	2000	19	105
Sep-17	Team C	2500	26	96
Oct-17	Team A	1100	11	100
Oct-17	Team B	2200	21	105
Oct-17	Team C	2900	29	100

What I would like to get is a table, where I can calculate sum of all transactions per month by sum of all co-workers per month:

Period	Transactions	Co-workers	No of transactions per co-worker
Sep-17	5300	55	96
Oct-17	6200	61	102

Do you happen to know if there is any quick fix in DAX I could use to calculate it?

[cs_skit · Accepted solution]

You need a measure

TransPerWorker = ROUND(DIVIDE( SUM(Transactions[Column2]);SUM(Transactions[Column3]);0);0)

then just put it in a Matrix to aggregate: 

[matal4]

Thanks, that is exactly what I needed!