Unable to filter a count by a slicer from another table

[wlandry12]

I may be coming up short on my understanding of data modeling, but I can't seem to figure out why my 'Shops'[Shop] slicer will not filter a card for Count of 'drawings'[DrawingID] based on the Shop selection.

Is it because the Shop filter stops short at the 'productioncontrolitems' table due to the directions of the relationships?

Is there a measure I could create to establish a filterable relationship between 'Shops'[Shop] and 'drawings'[DrawingID]?

[lbendlin · Accepted solution]

Is it because the Shop filter stops short at the 'productioncontrolitems' table due to the directions of the relationships?

That's exactly right.  "You can't get there from here".

You probably need to rethink the characteristics for your tables. Looks like the Drawings table is more a fact table rather than a dimension.  So the arrow should probably point into the Drawings table, not out of it.

Are you familiar with the concepts of star schema or snowflake schema?

[lbendlin · Accepted solution]

Is it because the Shop filter stops short at the 'productioncontrolitems' table due to the directions of the relationships?

That's exactly right.  "You can't get there from here".

You probably need to rethink the characteristics for your tables. Looks like the Drawings table is more a fact table rather than a dimension.  So the arrow should probably point into the Drawings table, not out of it.

Are you familiar with the concepts of star schema or snowflake schema?

[wlandry12 · Accepted solution]

I'm not very familiar with those schema concepts, but you make a good point about pointing the arrow into the Drawings table. I set the cross filter direction to "Both" between that table and the productioncontrolitems table and was able to get the Shop slicer to filter the Drawing Count card.