Count services that occur during same time frame

[biroo88]

Hello,

I am trying to get a count of services recieved per person_id that cross time frames.  I am getting counts, but unsucessfully getting the intended result. For example, 1001013321 should only be a value of 1 since the enrollements did not cross dates. Any help would be appreicated in detereming the correct calculation to find the number of enrollements occuring at the same time for a person. 

 

[v-stephen-msft · Accepted solution]

Hi @biroo88 ,

You can try the following measure:

Measure =
CALCULATE (
    COUNT ( 'Table'[ServiceCategory_ID] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        [Person_ID] = MAX ( 'Table'[Person_ID] )
            && [ServiceCategoryReceviedEndDate]
                = MAX ( 'Table'[ServiceCategoryReceviedEndDate] )
            && [ServiceCategoryReceviedStartDate]
                = MAX ( 'Table'[ServiceCategoryReceviedStartDate] )
    )
)

Best Regards,

Stephen Tao

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