Dataset with 2 x tblCalendars and Calculation Group

[Kudy]

Hi,

I need a dax code for Calculation Group that can Remove existing relationship from a measure. 
my Measure that has an existing relationship has USERELATIONSHIP function and I cannot remove that relationship through my Calculation Group.

My fact table has two date fields: OrderDate & ShipmentDate;


- OrderDate has an active relationship with tblCalendar1 and inactive relationship with tblCalendar2, in order to compare [Sales] for two different dates;

Dax for measures:

Sales = SUM(tbl_InternetSales[SalesAmount]);

Sales2 =

CALCULATE(

    [Sales],

    ALL(tblCalendar1),

    USERELATIONSHIP(

        tbl_InternetSales[OrderDate],

        'tblCalendar2'[Date]

    )

)

works perfectly!

Here is my problem starting ↓

- ShipmentDate has an inactive relationship with tblCalendar1 and tblCalendar2, so I could swith [Sales] measure to [Sales (by ShipmentDate)] in Calculation Groups. 

I think the problem is here in ALL. 

Code above for Calculation Group:

By ShipmentDate =

VAR _filter_Sales_by_tblCalendar1Date_as_ShipmentDate =

CALCULATE(

    SELECTEDMEASURE(),

    USERELATIONSHIP(

        tbl_InternetSales[ShipmentDate],

        tblCalendar1[Date]

    )

)

VAR _filter_Sales_by_tblCalendar2Date_as_ShipmentDate =

CALCULATE(

    SELECTEDMEASURE(),

    ALL(tbl_InternetSales[OrderDate]),

    USERELATIONSHIP(

        tbl_InternetSales[ShipmentDate],

        tblCalendar2[Date]

    )

)

RETURN

IF(

    ISSELECTEDMEASURE([Sales2]),

    _filter_Sales_by_tblCalendar2Date_as_ShipmentDate,

    _filter_Sales_by_tblCalendar1Date_as_ShipmentDate

)

[lbendlin]

What was your reason for having two calendar tables?  

[Kudy]

For comparison of two custom dates, eg March 1-3 vs  March 4-6

[lbendlin]

Make both of them disconnected (inactivate the relationships)  and use measures and TREATAS to find the data to compare.