Dynamic calculation based on slicer selection

v-jiascu-msft after quite a bit of effort, I tweaked the formula a bit and got it working. Thanks for your help. 

Just one final question - is there a way to get the actual costs based on different rates for different time periods? E.g. For one resource, if the resource has $30/hr for Jan, cost = [work time] * 30, else cost = [work time] * rate_selected. I tried DATEDIFF but could not quite get it. Thanks.

Daily Emp Cost New = 
VAR minIndex =
CALCULATE (
MIN ( 'Work Details'[Index] ),
ALLEXCEPT ( 'Work Details', 'Work Details'[Name], 'Work Details'[Work date] ),
'Work Details'[Employee Type] = "Full-time"
)
VAR dailyhours =
CALCULATE (
SUM ( 'Work Details'[Work Time] ),
ALLEXCEPT ( 'Work Details', 'Work Details'[Name], 'Work Details'[Work date] )
)
VAR rate_selected =
IF (
HASONEVALUE ( Rate[Rates] ),
LOOKUPVALUE (
Rate[Value],
Rate[Name], MIN ( 'Work Details'[Name] ),
Rate[Rates], MIN ( Rate[Rates] )
),
LOOKUPVALUE (
Rate[Value],
Rate[Name], MIN ( 'Work Details'[Name] ),
Rate[Rates], "Rate"
)
)
RETURN
IF (MIN ( [Employee Type] ) = "Full-time", IF ( MIN ( 'Work Details'[Index] ) = minIndex, IF (SELECTEDVALUE ( 'Work Details'[Weekend] ) = FALSE (), 8* rate_selected, IF(SELECTEDVALUE ( 'Work Details'[Weekend] ) = TRUE(), 0, MIN ([Work Time]) * rate_selected)),IF(MIN ( [Employee Type] ) = "Contractor", MIN ( [Work Time] ) * rate_selected,0)),MIN ( [Work Time] ) * rate_selected)