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

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 

I haven't used CROSSFILTER before, but going to give it a try!