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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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