Forum Discussion

LuizKoller's avatar
LuizKoller
Resolver I
1 year ago
Solved

USERELATIONSHIP x CROSSFILTER

Hello!

 

When I use CROSSFILTER in inactive Relationship, do i still need use USERELATIONSHIP, or the CROSSFILTER activates the relation for that measure?

 

 

Didnt find how its works in Microsoft Docs

  • hi LuizKoller ,

     

    they are of different use.

    CROSSFILTER only sets the cross-filtering direction of an active relationship, while USERELATIONSHIP activate a backup/secondary inactive relationship.

  • Right. The only reason to use both would be if you want to crossfilter on an inactive relationship.

2 Replies

  • hi LuizKoller ,

     

    they are of different use.

    CROSSFILTER only sets the cross-filtering direction of an active relationship, while USERELATIONSHIP activate a backup/secondary inactive relationship.

    • AlexisOlson's avatar
      AlexisOlson
      Super User

      Right. The only reason to use both would be if you want to crossfilter on an inactive relationship.