Ignoring an active relationship

Hi Anonymous ，

>>So basically i need to find how to change the measure so that it ignore only the active date relationship.

You can use REMOVEFILTERS function in your formula to clear filters from the specified tables or columns. You can refer to https://docs.microsoft.com/en-us/dax/removefilters-function-dax

You can try something like:

The measure =
VAR days =
    MAX ( days[days] )
VAR amount =
    CALCULATE (
        SUM ( 'Table'[amount] ),
        FILTER (
            ALLSELECTED ( Table ),
            'Table'[first_date] + days
                <= MAX ( '_T Date'[Date] )
                && 'Table'[first_date] + days
                    >= MIN ( '_T Date'[Date] )
        ),
        REMOVEFILTERS ()
    )
RETURN
    amount

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

Best Regards,

Dedmon Dai