Dividing a Measure into Multiple Categorizations

Hi all,

I'm struggling with this graph I'm trying to create, and I could really use some help.

This is what my data looks like (just the upper three tables: Products, Entries and Durations). 

My model looks like this: 

What I'm trying to do is to make a graph of the number of products that have a valid entry in a selected date (range), and categorize this number (of products) using the (valid) durations. By 'valid', I mean that the selected date (range) is in between 'In' and 'Out'(for 'Entries') or in between 'Start' and 'End' (for 'Durations'). Entries never overlap, but Durations can overlap.

For the 'have an entry' measure I use:

have an entry = 
CALCULATE (
    COUNT ( Entries[ID] ),
    FILTER (
        Entries,
        Entries[In] <= MAX ( 'calendar'[Date] )
            && (
                Entries[Out] >= MIN ( 'calendar'[Date] )
            )
    )
)

For the 'have a duration' measure I have:

have a duration = 
CALCULATE (
    COUNT( Products[ID] ),
    FILTER (
        Durations,
        Durations[Start] <= MAX ( 'calendar'[Date] )
            && Durations[End] >= MIN ( 'calendar'[Date] )
            && Durations[Start] <> BLANK ()
    )
)

You can see the results of these measures in the 'Final Result' table in my first screenshot.

But at this point, I'm stuck. 😞

What I need to do is graph the 'have an entry' measure by date and categorize using the Durations table's 'Category'.

The twist is that it can happen that one valid entry has two valid durations. In this example, ProductID = 288 has two valid durations, which includes one with category 'C'. Whenever there is a mix with category 'C' with another one, I want to assign 60% of that entry to category C and 40% of that entry to another (A or B).

The parts with category 'C' should be highlighted in color 'Y'.

The parts with category 'A', 'B' or an unknown category should be highlighted in color 'X'.

In this example the final result in a graph should be:

• If a product has a valid entry and only one (or more) valid duration(s) with category 'C', the entry should be entirely colored in 'Y'.
• If a product has a valid entry and 100 valid durations with categories A and B and only one with category 'C', the entry should still be 60/40 colored in Y/X.
• If a product has a valid entry and no valid durations (so category 'Unknown'), it should be colored 'X'.
• If a product has a valid entry and one valid durations with category A or B, it should be colored 'X'.

... and so forth..

I hope this makes sense! And I really hope one of you is willing to invest the time to help me out on this one. It will be appreciated immensly!

🙃

EDIT: To clarify: I want to end up with one (or two) 'block(s)' in my graph with totals for 'X' and 'Y'. So in the example above there would be a block for 'X' with a total amount of 2.4 and a block for 'Y' with a total amount of 0.6. 'X' + 'Y' is always an integer.