Measure counting dates depending on employee vacation calender

[KimStahl94]

Hello there,

I am trying to count the dates that each employee has to work until EOY. Therefore I need to filter the date table for each employee within the measure to return the correct amount of days to count. I have no problem filtering out the weekends but for the vacation days I am currently subtracting the amount of days listed in their related vacation calender.
So here is some sample data:

The Measure should return 363 for ID 1, 362 for ID 2 and 361 for ID 3.
It is important to not just subtract the amount of listed vacation days because I also need to check If they even are supposed to work on the specific date depending on their work schedule. This information is listed in another table which I can implement in the Measure if this issue has been solved.

Looking foreward to your responses. 

Regards

Kim

[KimStahl94 · Accepted solution]

Hello there,

so I was able to find a solution and wanted to share. Sry for bothering, but I tried fixing this issue since quite a time and finally I found the correct syntax as followed:

Remaining Days =

CALCULATE (

COUNT ('Calendar'[Date] ) ,

'Calendar'[Date] IN

EXCEPT (

ALL ( 'Calendar'[Date] ),

VALUES ( 'Vacation Dates'[Vacation Days] )

)

)

Hopefully some of you finds value in this information.

Regards

Kim