Filter within a measure

Scheduled vs Actual Effort with Filters = //try this one
CALCULATE(
DIVIDE(
SUM(PVEffort[ActualEffort]),
SUM(TimePlanned[PlannedEffort])
),
NOT(ISBLANK('TableName'[Organisation])),
'TableName'[WorkType] = "Installation" || 'TableName'[WorkType] = "Absence"
)

Hi jalaomar ,

mh2587 Good answer! And you can also try this:

Measure = 
CALCULATE(
    DIVIDE(
        SUM(PVEffort[ActualEffort]),
        SUM(TimePlanned[PlannedEffort])
    ),
    'PVEffort'[Organisation] <> BLANK(),
    'PVEffort'[WorkType] IN { "Installation", "Absence" }
)

I've tested both DAXs and they're both correct.

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