Calculate correct total for a ratio

---

Yggdrasill wrote:
Thank you for the review!

However I have to be able to see one or multiple employees which are stores in the resource table.

---

in that case, you can probably get away with something like this...

Mandatory STAGE =
VAR _mandatoryHours = 7.5 //mandatory hours per day

VAR __cur_resource_last_date = SELECTEDVALUE( Resource[EndDate] )

//WorkRatio from Calendar is either 0 or 1 based on the day of the year
VAR _daycalc =
    CALCULATE(
        SUM( Calendar[WorkRatio] ) * _mandatoryHours,
        FILTER(
            'Calendar',
            AND(
                'Calendar'[Date] <= 'Last Refreshed'[LastRefreshed],
                'Calendar'[Date] <= __cur_resource_last_date
            )
        )
    )
        * AVERAGE( Resource[Work Ratio%] ) //some resource are not 100% full time
VAR _calc = _daycalc * [Employee Count] //distinct count of resources
RETURN
    IF(
        ISINSCOPE( 'Calendar'[Date].[Year] ),
        _daycalc,
        _calc
    )
EVALUATE
 ( 'calendar' )

...then create another measure that references the one above at the resource level...

 Mandatory =  
    SUMX(
        /* or whatever the grain of the resource is called */
        VALUES( 'Resource'[ResourceID] ), 
        [Mandatory STAGE]
    )

This is a calculation needs to happen at the resource/day grain... so there's probably a better way to handle.