how to tie units to a time productivity matrix by date...like Month to Month, etc

[Karolina411]

Hello Dax Experts.  I am drawing blanks with this issue:  Every month each employee has 7200 of productivity units and I need to measure their minutes calculated by 7200 each month. I can do that for one month but when I change my filters to 2 months it doubles, then 3 months it triples and so forth..the %expected triples.  I know this is a basic fix but I cannot work it out.

I am just taking the total minutes worked x Productive units then x # employees then dividing it by the 7200 x # of employees so the denominator is where I need help..how do we factor in a time into a static 7200 minutes per month?  Thank you!

[BrianConnelly]

You need to create a summary table with division and sum it.  For example:

total minutes worked x Productive units then x # employees then dividing it by the 7200 x # of

MeasureName =
Var summaryTable = SUMMARIZE(table, employee, month, "Worked Minutes", SUM(Minutes),"Division",7200, "Formula", DIVIDE(SUM(Minutes),7200,0))

RETURN SUMX(summaryTable ,[Formula])

[Karolina411]

I will practice Summary Tables... I used a simpler added DAX from amitchandak but will get to know this approach!  Thank you!

[amitchandak · Accepted solution]

@Karolina411 , One way is to calculate no of the month

measure

= distinctcount(Table[Month Year]) *7200

Or have this column in your date table

new column = 7200

and use that in measure

[Karolina411]

thank you so much! this simple added part with the date was what I needed!!  I am so relieved!!!!