How to do Deactivate the Active relationship or Cross filter creating performance issues in dax

[ganesanr1002]

Hi , How to do Deactivate the Active relationship between two table . I used calculate([sales],Crossfilter(Static[Day],DimDate[Day],None)) This is taking too much time for loading data.  But this creating bigger issues . Because i have a Static Table which have the Days that is connected to Dim date [day] . Sample screenshot i attached below . Here if you see M-2,M-2,M ,+/% All are in one measure used Conditional Statement to plot it . 

Is their any other way to plot that will great or if it possible to deactivate the relationship with better measure . 

Kindly help .

[lbendlin · Accepted solution]

There is no need to have an active relationship. Keep both of them inactive, and then activate as needed via USERELATIONSHIP.