Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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.
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.
"measure on the cross filtered visual has a USERELATIONSHIP embedded"
How do I embed a measure?
The measure being cross filtered must be in this form
CALCULATE([measure],USERELATIONSHIP(. , ,))
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |