Forum Discussion

wskallmeyer's avatar
wskallmeyer
Icon for Advocate II rankAdvocate II
9 years ago

Filtered row in data model for all tables joined

Hi All,   I have added a parameter and then applied it to a column to get my filtered rows.  That works fine.  In my data model EmployeeTable is joining on SalesTable with a unique EmployeeId.  I a...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

Please post a picture of your data model relationships if you can. I suspect that you need to configure the cross-filter direction on the relationships appropriately to achieve what you desire but I'd have to see the relationships first to confirm.

wskallmeyer's avatar
wskallmeyer
Icon for Advocate II rankAdvocate II
9 years ago

Okay, this scenario is similar.  I applied the parameter to filter the Tickets table to show only 1 department.  1 ticket will have mutiple metrics associated with it (eg, open, pending, close).  I want the Metrics table to also be filtered down to the same department using the table relationship.

 

  • wskallmeyer's avatar
    wskallmeyer
    Icon for Advocate II rankAdvocate II
    9 years ago

    I have also recently tried Cross Filter Direction: Both.  And still the child table does not eliminate rows based on the filtered rows in the parent table.

     

    I have also deleted the Filtered Rows step and then added it back to see if that would re-apply the filter.  Without success.

     

    Scott

    • wskallmeyer's avatar
      wskallmeyer
      Icon for Advocate II rankAdvocate II
      9 years ago

      Any thoughts?  Is this a bug?

      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper User
        9 years ago

        do you see blank on your visual?