I have connected my Calendar Table with two dates for Project Tracking Data

[saadghojaria]

Problem Statement : I want to track projects running , starting and ending in specific date range ( I'm using this range in slicer) 

My Calendar Table looks like this it is connected to my Projects startdate and enddate

ongoing =

    VAR MinDate =

        CALCULATE ( MIN ( 'Calendar'[Date] ), ALLSELECTED ( 'Calendar'[Date] ) )

    VAR MaxDate =

        CALCULATE ( MAX ( 'Calendar'[Date] ), ALLSELECTED ( 'Calendar'[Date] ) )

    VAR StartDateFiltered =

        CALCULATETABLE (

            'Master Projects',

            USERELATIONSHIP('Master Projects'[Start Date], 'Calendar'[Date])

        )

    VAR EndDateFiltered =

        CALCULATETABLE (

            'Master Projects',

            USERELATIONSHIP('Master Projects'[End date], 'Calendar'[Date])

        )

    RETURN

        COUNTROWS (

            FILTER (

                INTERSECT(StartDateFiltered, EndDateFiltered),

                ('Master Projects'[Start Date] <= MaxDate && 'Master Projects'[End date] >= MinDate)

            )

        )

ending =

    VAR MinDate =

        CALCULATE ( MIN ( 'Calendar'[Date] ), ALLSELECTED ( 'Calendar'[Date] ) )

    VAR MaxDate =

        CALCULATE ( MAX ( 'Calendar'[Date] ), ALLSELECTED ( 'Calendar'[Date] ) )

    RETURN

        CALCULATE (

            COUNTROWS ( 'Master Projects' ),

            FILTER (

                'Master Projects',

                ('Master Projects'[End date] >= MinDate

                    || 'Master Projects'[End date] <= MaxDate)

            ),

            USERELATIONSHIP('Master Projects'[End date], 'Calendar'[Date])

        )

starting =

    VAR MinDate =

        CALCULATE ( MIN ( 'Calendar'[Date] ), ALLSELECTED ( 'Calendar'[Date] ) )

    VAR MaxDate =

        CALCULATE ( MAX ( 'Calendar'[Date] ), ALLSELECTED ( 'Calendar'[Date] ) )

    RETURN

        CALCULATE (

            COUNTROWS ( 'Master Projects' ),

            FILTER (

                'Master Projects',

                ('Master Projects'[Start Date] >= MinDate

                    && 'Master Projects'[Start Date] <= MaxDate)

            ),

              USERELATIONSHIP('Master Projects'[Start Date], 'Calendar'[Date])

        )

Current Output : 

Expected output is in Excel Sheet I checked for year 2024 it should be around 100 projects in total including all statuses. 

Please help I tried many different solutions.

Referred code : Solved: How do I create a report which shows running, new,... - Microsoft Fabric Community

[amitchandak · Accepted solution]

@saadghojaria , check if one of two methods can help

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

Matrix as Project plan Visual: https://youtu.be/R25QoiyoSVs