Forum Discussion
Helper IICross filtering with userelationship
Hey guys,
I have a problem with cross-filtering. I am trying to filter a table visual by date from a column chart in the same sheet. The problem is that I use several inactive relationships and no active relationship (because I read somewhere that USERELATIONSHIP works correctly only with inactive relationships).
1. is there a way to use crossfiltering with inactive relationships?
2. If not, how would you recomend setting up correct cross filtering in this case that I am attaching:
https://drive.google.com/file/d/1THHewTS8uO-wBUF55w6fumiNzcqgIFPz/view?usp=sharing
Any help much appreciated
There is no 1 correct method, however it is normal to have 1 active relationship. It is not a requirement to have zero active for USERELATIONSHIP to work.
Cross filtering works on active relationships. If you want to use an inactive relationship, you need to ensure the measure on the cross filtered visual has a USERELATIONSHIP embedded.
3 Replies
- MattAllington
Community Champion
There is no 1 correct method, however it is normal to have 1 active relationship. It is not a requirement to have zero active for USERELATIONSHIP to work.
Cross filtering works on active relationships. If you want to use an inactive relationship, you need to ensure the measure on the cross filtered visual has a USERELATIONSHIP embedded.
Almantas32"measure on the cross filtered visual has a USERELATIONSHIP embedded"
How do I embed a measure?
- MattAllington
The measure being cross filtered must be in this form
CALCULATE([measure],USERELATIONSHIP(. , ,))