Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 |
---|---|
85 | |
76 | |
72 | |
69 | |
56 |
User | Count |
---|---|
104 | |
99 | |
92 | |
78 | |
69 |