Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Ignore Existing Relationship

My Lead table contains 2 dates, Open date & Close date.  Currently I have an active relationship between the Close date and a date table for other reports.   I'm trying to create a table showing th...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Ok, got it. If you just want to remove the relationship, you can wrap your calculation with a CALCULATE function and CROSSFILTER function.CROSSFILTER can be used to remove the active relationship by mentioning the filter direction as none, this retains the other existing filters. Based on your exact need, you can explore how this option can be used in your case.

     

    something like : CALCULATE( <calculation>, CROSSFILTER(dt1,dt2,none)

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks Anonymous 

 

Currently I don't have an inactive relationship set up.  Is there a way to do it without setting an inactive relationship?  I tried it and it messed up a bunch of other reports.  If that's the only way to do it, I'll try and set up the other reports differently.

SouravJha's avatar
SouravJha
Regular Visitor
8 months ago

Yes. You can use TREATAS function to setup virtual relationship that can be used for filtering.