Summing a dynamic measure

[Tomhayw]

Hi there,

I'm having trouble with one of my measures:

I have this table of utilisation rates. The 'Fact' column is just a sum of days worked by an employee.

The 'Target' column is the total number of days available for that person in that month. So for example, if they joined half way through the month, only half the total days would be available. 

Target  =

var f = MIN('Clockify Time Entries'[FirstDateWorked])

var result =

CALCULATE(DISTINCTCOUNT('Calendar'[Date]),

    FILTER('Calendar',

        not 'Calendar'[Weekend ONLY]&&

        'Calendar'[Date]>=f&&'Calendar'[Date]<=today()))

return

result

Though, as you can see, the total at the bottom is 22, but I want it to be the sum of that column., and the % column is a sum, whereas I would like it to essentially be (total hours / hours available)

I don't mind creating another measure whose sole purpose is to sum that column up but I'm not sure how to do it.

Any help would be great!

Thanks,

Tom

[Tomhayw · Accepted solution]

I've figured it out:

I used =SUMX(VALUES( Target, username)

to allow me to sum all the different rows together.