Forum Discussion

ginalu's avatar
ginalu
Helper I
2 years ago
Solved

failed filter across multiple tables

I am trying to filter across multiple tables. The screenshot below shows three tables and their relationships. I want to filter USER[country] to view the plan statistics, but it’s not working.

 

Need Help
  • SamWiseOwl's avatar
    SamWiseOwl
    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 -> 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)

2 Replies