Count services that occur during same time frame

Question

Hello,&nbsp;I am trying to get a count of services recieved per person_id that cross time frames.&nbsp; I am getting counts, but unsucessfully getting the intended result. For example,&nbsp;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.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Accepted Answer

Hi&nbsp;biroo88&nbsp;,
&nbsp;
You can try the following measure:
Measure =
CALCULATE (
    COUNT ( 'Table'[ServiceCategory_ID] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        [Person_ID] = MAX ( 'Table'[Person_ID] )
            &amp;&amp; [ServiceCategoryReceviedEndDate]
                = MAX ( 'Table'[ServiceCategoryReceviedEndDate] )
            &amp;&amp; [ServiceCategoryReceviedStartDate]
                = MAX ( 'Table'[ServiceCategoryReceviedStartDate] )
    )
)

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

Forum Discussion

Count services that occur during same time frame

1 Reply

Related content

Counting nulls

Internal service error during Power BI Service refresh – recurring issue

Error during refresh

Error during refresh

Error during update