Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
matal4
New Member

Sum by distinct period

Hello,

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

 

PeriodTeamTransactionsCo-workersNo of transactions per co-worker
Sep-17Team A8001080
Sep-17Team B200019105
Sep-17Team C25002696
Oct-17Team A110011100
Oct-17Team B220021105
Oct-17Team C290029100

 

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:

PeriodTransactionsCo-workersNo of transactions per co-worker
Sep-1753005596
Oct-17620061102

 

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

1 ACCEPTED SOLUTION
cs_skit
Resolver IV
Resolver IV

You need a measure

 

 

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

 

then just put it in a Matrix to aggregate: 

View solution in original post

2 REPLIES 2
cs_skit
Resolver IV
Resolver IV

You need a measure

 

 

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

 

then just put it in a Matrix to aggregate: 

Thanks, that is exactly what I needed!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.