The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
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.
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.
User | Count |
---|---|
11 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
23 | |
14 | |
14 | |
9 | |
7 |