Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Formula Help - Filter by Another Column

I am trying to write the following formula with the following tables Numerator should be the (Sum of Total Person Hours) - (Sum of Total Person Hours where Hour Type equals Non-Working) Denominator...
Need Help
FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi Anonymous 

try to add a column in the Resource table:

 

 

column = 
VAR _nonworkinghours= 
SUMX(
    FILTER(
        TimeLogged,
        TimeLogged[Resource Name] = [Resource Name]
            &&TimeLogged[Hour Type] = "Non-Working"
    ),
    TimeLogged[Person Hours]
)
RETURN
DIVIDE( [Working Hours] - _nonworkinghours, [Working Hours])

 

it worked like: