Forum Discussion

matal4's avatar
matal4
New Member
9 years ago
Solved

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":   Period Team Transactions Co-workers No of trans...
  • cs_skit's avatar
    cs_skit
    9 years ago

    You need a measure

     

     

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

     

    then just put it in a Matrix to aggregate: 

cs_skit's avatar
cs_skit
Icon for Resolver IV rankResolver IV
9 years ago

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's avatar
matal4
New Member
9 years ago

Thanks, that is exactly what I needed!