Forum Discussion
failed filter across multiple tables
- 2 years ago
Hi ginalu
If you follow the line along:
User -> Org (user can filter Org)
Org <- Plan (plan can filter Org)
You are trying to do:
User -> Org -> PlanThere are two ways to do this:
Change Plan -> Org to Plan <-> Org
Use a Dax Calculation:
CrossFilter Plan Org =
Calculate(
[Your calculation] , CrossFilter( Plan[Org_id], Org[Org_id], both))This video explains the CrossFilter function: CROSSFILTER - DAX Guide - YouTube
This one explains the issue with ambiguity: Bidirectional relationships and ambiguity (youtube.com)
Hi ginalu
If you follow the line along:
User -> Org (user can filter Org)
Org <- Plan (plan can filter Org)
You are trying to do:
User -> Org -> Plan
There are two ways to do this:
Change Plan -> Org to Plan <-> Org
Use a Dax Calculation:
CrossFilter Plan Org =
Calculate(
[Your calculation] , CrossFilter( Plan[Org_id], Org[Org_id], both))
This video explains the CrossFilter function: CROSSFILTER - DAX Guide - YouTube
This one explains the issue with ambiguity: Bidirectional relationships and ambiguity (youtube.com)