ID Count per each calendar date

Hi everyone,

I have the following issue that I need your help to solve.

the following is an example of the dataset I have:

my goal is to get the count of membership_id per day like the example below:

in SQL, I can to join the first table with the calendar table and get the following results:

SELECT *
FROM First_Table t
LEFT OUTER JOIN Calendar c ON c.date >= t.Start_Date AND c.dt_dt <= t.End_Date

I could import the results to PowerBi and and count the memberships per day. however, the SQL query generates a huge amount of records which causing issues due to the restrictions we have.

I hope there's a way to achieve that in PowerBi.

Thanks