Count with Filter that has two dates on a line visual

[Anonymous]

I have two tables called DateTbl and ItemTbl. DateTbl is my date lookup while ItemTbl has columns named Item_Number, Start_Date and End_Date. My relationship is on Start_Date with the DateTbl.

However, I want to count item_Number based on Start_Date and End_Date in the filter expression and create a line visual with the count Item on y-axis and Date[Date] on x-axis but I am struggling to get it work since it involves Start_Date and EndDate and relationship is on Start_Date.
For example, I hard coded Start_Date and End_date the dax below:

CALCULATE (
    COUNT ('Item_Tbl'[Item_Number]),
    
       FILTER('Item_Tbl','Item_Tbl'[Start_Date] <= DATE(2021,10,18)),
       OR('Item_Tbl'[End_Date] > DATE(2021,10,18)
           ,'Item_Tbl'[End_Date] = BLANK())
        )

But I don't want to hard code the date from ItemTbl and want place it in a line chart.

and the Date looks at the last 3 months.

Please help

[amitchandak · Accepted solution]

@Anonymous , Seem very similar to active employee of HR, refer

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

[Anonymous]

Thank you. it works