Forum Discussion

dsj8wksnnckk's avatar
dsj8wksnnckk
Resolver I
2 years ago
Solved

Count resources on bench

Hi, I need help with counting people on bench. I have the following tables: Table1 [Booking] with columns: Resource Name, Project Type, Status Name, Start Date, Duration Table2 [Resourc...
Need Help
  • dsj8wksnnckk's avatar
    dsj8wksnnckk
    2 years ago

     


    The Billing Type is a Calculated Column using data on Project and additional dimensional table containing more detailed information on Project.

    As you can see, there are multiple instances of Duration in 1 day.

    Definition of bench: a Resource is on bench if it has NO duration for Status Name = Hard && Project Type = Commercial && Billing Type = Chargeable

  • dsj8wksnnckk's avatar
    dsj8wksnnckk
    2 years ago

    I resolved this:

    CountOnBench =
    SUMX(
        VALUES('Resources[Resource Name]'),
        [IsOnBench]
    )

    IsOnBench =
    IF(
        [Allocation] = 0,
        1, BLANK()
    )


dsj8wksnnckk's avatar
dsj8wksnnckk
Resolver I
2 years ago

I resolved this:

CountOnBench =
SUMX(
    VALUES('Resources[Resource Name]'),
    [IsOnBench]
)

IsOnBench =
IF(
    [Allocation] = 0,
    1, BLANK()
)