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

or you can plot the Resource Name from Resource table with a measure like:

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

 

it worked like: