Need help with a measure when selecting more than one category in a slicer.

[Traceout]

Here's what I'm looking at. I want to get a rolling number of customers impacted.

1. The customers are broken up into different zones.

2. Each impact has a start_date and an End_date and customers. 

3. If the start date of an impact is after the end_date of a previous impact, the customers of the previous impact are no longer added into the rolling customers impacted.

For example:

I have the following measure: 

Rolling Customers Impacted2 =

VAR currentStartDate = SELECTEDVALUE('Sheet2'[Start_Date])

RETURN

    CALCULATE(

        SUM(Sheet2[Customers]),

        ALLEXCEPT(Sheet2,Sheet2[Zone]),

        'Sheet2'[Start_Date] <= currentStartDate,

        'Sheet2'[End_date] >= currentStartDate

    )

When I select one zone in the slicer it calculates the running customers correctly but when I select two or more zones it calculates the running customers for each zone instead of combining the zones and doing a running total by start_date. 

Example data: 

Example1: 

When 1 zone is selected: 

Example2:

When 2 zones are selected: 

sorted by date

Sorted by zone: 

As you can see it's calculating each zone independently which is what it should be doing but I'm not sure how to get the result I'd like. 

Example 3: When sorting by 2 or more zones - What I'm aiming for: 

Any help would be much appreciated! Thanks!

[v-henryk-mstf]

Hi @Traceout ,

Can you provide the relevant test data so that I can answer your question as soon as possible? Looking forward to your reply.

Best Regards,
Henry

[Traceout]

@v-henryk-mstf 

I've attached a .pbix with the test data. Let me know if you have any questions, I appreciate the help. 

https://drive.google.com/file/d/1g3LLsJH9xkmJc0PN0OVWOzmbL4IGYm9x/view?usp=sharing

[Traceout]

I should probably also mention that there are more than 2 zones.