Forum Discussion

snolan175's avatar
snolan175
Frequent Visitor
2 years ago
Solved

Resource Utilisation - Different Target Percentage

I'm trying to create a utilisation report with two base tables:   One is the time entries broken down by resource and day, with each entry having a time category from the following; Internal, Absen...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi snolan175 ,

    I can give you an example:
    If you want to show the Efficiency Percentage of Person 1, just use this DAX to create a measure:

    Measure = 
CALCULATE(
    MAX('Table'[Efficiency Percentage]),
    'Table'[Resource] = "Person 1"
)

    If you need to calculate other Efficiency Percentages, please explain your calculation process in detail. I can try to write DAX for you.


    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi snolan175 ,

I can give you an example:
If you want to show the Efficiency Percentage of Person 1, just use this DAX to create a measure:

Measure = 
CALCULATE(
    MAX('Table'[Efficiency Percentage]),
    'Table'[Resource] = "Person 1"
)

If you need to calculate other Efficiency Percentages, please explain your calculation process in detail. I can try to write DAX for you.


Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

snolan175's avatar
snolan175
Frequent Visitor
2 years ago

Thanks Dino, I ended up using the selected value function rather than an absolute:

 

Target Utilisation = CALCULATE(MAX(Efficiency[Efficiency Decimal]),
    FILTER(Resource_Card_Excel,Resource_Card_Excel[No] = SELECTEDVALUE(Resource_Card_Excel[No]))
)