Countrows Outside date range in the slicer

Question

Hello&nbsp;I have a file with employees data along with the StartDate and the FinishDate of each emloyee.&nbsp;&nbsp;Now the requirement is to count rows where the StartDate is BEFORE min date of the slicer AND the FinishDate is AFTER&nbsp; the max date of the slicer!!!&nbsp;The slicer contains Date column from the date table wich is related to the fact table using StartDate, and also to EndDate (inactive relationship).&nbsp;I created a measure but it always returns Blank:&nbsp;I believe the blank value is because the measure looks for the values outside the selected date range...&nbsp;Thanks!&nbsp;&nbsp;

vahiddm · Accepted Answer

Hi&nbsp;Sab&nbsp;&nbsp;You need to use Filter in your calculate, try something like this:&nbsp;Calculate([All rows], Filter(all(People Overview),People Overview[Start Date]&lt;StartDate &amp;&amp;&nbsp;People Overview[Finish Date]&gt;EndDate))&nbsp;If this post&nbsp;helps, please consider&nbsp;accepting&nbsp;it as the solution&nbsp;to help the other members find it more quickly.Appreciate your Kudos!!&nbsp;

Forum Discussion

Countrows Outside date range in the slicer

1 Reply

Related content

COUNTROWS

Manage visuals outside Pbix

Develop Power Query outside Power BI or Excel

Multiple Filters (COUNTROWS)

Use AI Skill outside Fabric