Sum based on conditional date range

Hi All,

Struggling with a measure or even column to calculate my desired results, I suspect my required filters might be getting in the way but can't find a workaround.

Current Layout:

I've got a Table with two date ranges (Effective From and Effective To) the Effective To can be null.

I've added a Custom Column to calculate the total Active days for each row, and where it's null, it uses LocalNow as below:

if [EffectiveTo] is null 
then Duration.Days (DateTime.Date(DateTime.LocalNow()) - [EffectiveFrom]) 
else Duration.Days([EffectiveTo] - [EffectiveFrom])

I've added a Measure as a filter to my visual, displaying only accounts which is/was active within a date range slicer.

Filter = 
VAR _Range_Start =
    MIN ( 'Date'[Date Name] )
VAR _Range_End =
    MAX ( 'Date'[Date Name] )
RETURN
    IF (
        AND (
            MAX ( 'Managed Deposit Amount'[EffectiveFrom] ) >= _Range_Start,
            MAX ( 'Managed Deposit Amount'[EffectiveFrom] ) <= _Range_End
        )
            && OR (
                ISBLANK ( MAX ( 'Managed Deposit Amount'[EffectiveTo] ) ),
                MAX ( 'Managed Deposit Amount'[EffectiveTo] ) > _Range_End
            ),
        1,
        0
    )

Requirements:

I want to sum the value of a column (Daily Fee) multiplied by the number of Active days within the Date Range, for each row.

e.g.

A user sets a Date Range of 1-January-2022 to 20-January-2022

Row 1 is $200 for the full 20 days within the Date Range.

Row 2 is $100 because it was only active for 5 days within the Date Range.

Row 3 is $160 because it was only active for 16 days within the Date Range.

Current Data:

I've tried a handful of measures but nothing seems to be yielding my expected results. 
I've tried using this to hopefully multiply by the Daily Fee, but the results are incredibly wrong:

ActiveDaysInRange = 
VAR _Range_Start =
    MIN ( 'Date'[Date Name] )
VAR _Range_End =
    MAX ( 'Date'[Date Name] )
RETURN
IF(
    ISBLANK(
        [EffectiveTo]),
        DATEDIFF(_Range_End, [EffectiveFrom], DAY),
        IF(
            MAX([EffectiveFrom]) >= _Range_Start && MAX([EffectiveTo]) >= _Range_End,
            DATEDIFF(_Range_Start, _Range_End, DAY),
            DATEDIFF([EffectiveFrom], [EffectiveTo], DAY)
        )
)

Any assistance is greatly appreciated!