Count ID based on Date Condition from different table with Many to Many Relationship

Hi, PrathSable 

Based on your descirption, I created data to reproduce your scenario. The pbix file is attached in the end.

Team:

Person:

You may create a measure as below.

DistinctCountPerson = 
var tab = 
ADDCOLUMNS(
    ALL(Person),
    "Result",
    var _date = [Date]
    return
    IF(
        CALCULATE(
            COUNTROWS(Team),
            FILTER(
                'Team',
                _date>=[Start Date]&&_date<=[End Date]
            )
        )>0,
        1,0
    )
)
return
CALCULATE(
    DISTINCTCOUNT(Person[Person_id]),
    FILTER(
        tab,
        [Result]=1
    )
)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.