Need help with Day Count measure please

Hi RichOB , Thank you for reaching out to the Microsoft Community Forum.

Please try below (I assumed kennel as table name):

Day_Count =

SUMX(

    'Kennel',

    VAR StartDate = 'Kennel'[Start_Date]

    VAR EndDateRaw =

        IF(

            ISBLANK('Kennel'[End_Date]) || 'Kennel'[Status] = "Current",

            TODAY(),

            'Kennel'[End_Date]

        )

    VAR EndDate = MIN(EndDateRaw, TODAY())  -- Prevent future dates

    VAR DayCount =

        IF(

            NOT ISBLANK(StartDate) && NOT ISBLANK(EndDate) && StartDate <= EndDate,

            DATEDIFF(StartDate, EndDate, DAY) + 1,

            0

        )

    RETURN

        DayCount

)

If this helped solve the issue, please consider marking it “Accept as Solution” and giving a ‘Kudos’ so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.