Forum Discussion

Tomhayw's avatar
Tomhayw
Helper I
3 years ago
Solved

Summing a dynamic measure

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

 

Need Help
  • Tomhayw's avatar
    Tomhayw
    3 years ago

    I've figured it out:

     

    I used =SUMX(VALUES( Target, username)

     

    to allow me to sum all the different rows together.

1 Reply

  • Tomhayw's avatar
    Tomhayw
    Helper I
    3 years ago

    I've figured it out:

     

    I used =SUMX(VALUES( Target, username)

     

    to allow me to sum all the different rows together.