Countrows Outside date range in the slicer

[Sab]

Hello

I have a file with employees data along with the StartDate and the FinishDate of each emloyee. 

Now the requirement is to count rows where the StartDate is BEFORE min date of the slicer AND the FinishDate is AFTER  the max date of the slicer!!!

The slicer contains Date column from the date table wich is related to the fact table using StartDate, and also to EndDate (inactive relationship).

I created a measure but it always returns Blank:

I believe the blank value is because the measure looks for the values outside the selected date range...

Thanks!

[VahidDM · Accepted solution]

Hi @Sab 

You need to use Filter in your calculate, try something like this:

Calculate([All rows], Filter(all(People Overview),People Overview[Start Date]<StartDate && People Overview[Finish Date]>EndDate))

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!