urgent help!!

[xiumi_hou]

Hi There, 

The problem is i only have 1 date table, but in my dax...i have two different date (entry date and exit date) to be consider as the criteria.... but it does not allow two relationship to be built..... how can i revise this? 

Individual Served =

CALCULATE(

    DISTINCTCOUNT('01 Contact'[ClientID]),

    FILTER(

        '~02 programstatus',

        '~02 programstatus'[EntryDate] <= MAX('d_Date'[Date])  &&

('~02 programstatus'[ExitDate] >= MIN('d_Date'[Date]) || isblank('~02 programstatus'[ExitDate]))  &&

        ISBLANK('~02 programstatus'[UnPendingDate])

    ),

    FILTER(

        '~03 Clients',

        '~03 Clients'[MISNonRegistered] = 0 &&

        NOT(ISBLANK('~03 Clients'[ClientID]))

    ),

    '~02 programstatus'[Deleted] <> "Yes"

   // USERELATIONSHIP(d_date[Date],'~02 programstatus'[EntryDate])

)

[Ritaf1983]

Hi @xiumi_hou 
Check the finction : userelationship()

https://www.youtube.com/watch?v=fOcgIuaJHEs

If it doesn't help 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

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