Distinctcount with crossfilter issue

Hello Anonymous ,

I tried to share with you my pbix file but it doesn't work. So I'm joining a table with my dates.

In power BI, I created a new table that provides me all the date between 01/01/2019 and 31/12/2021. And I would like thanks to this table to have the number of ID that have a start date before the date of this new table and a end_date after it. It will be the number of ID available at this date.

But as I have some similar ID, Hence I only want the count for unique value. That's why I used distinctcount.

There is an active relation between my table with dates between 2019 and 2021 and the table below by the start_date.

I tried this code to have the amount of unique ID available to a given date but it doesnt work.

CALCULATE(DistinctCOUNT(Base_PBI[Ent]),FILTER(Base_PBI,Base_PBI[Start_Date]<=max('new measure'[Date]) && ((Base_PBI[End_Date]>DATE(YEAR(TODAY()),month(today()-1),31)) || Base_PBI[End_Date]>max('new measure'[Date]))),CROSSFILTER(Base_PBI[Start_Date],'new measure'[Date],None))

table with my ID, start_Date and End_Date

I would like to have a report like this (the number of unique ID available are random)

Thank you so much for your help!

Have a nice day!