Forum Discussion

orihime0's avatar
orihime0
Regular Visitor
1 year ago
Solved

Modelling Many to Many Relationship and Counting Unique and Non-Unique Relationships

I have 2 fact tables that consist of unique values that are related to one another through an additional item-relationship: Fact 1 Fact 2   Item Relation Table - As seen here, not eve...
Need Help
  • mickey64's avatar
    mickey64
    1 year ago

    For your reference.

     

    "Model view"

     

    Selection "B" of "ItemB" on "Report view"

     

    Selection "2" of Item A on "Report view"

     

     

danextian's avatar
danextian
Super User
1 year ago

I'm curious why Item A has a completely different set of values from Item B. How do you know which Item A value is related to that from Item B?

orihime0's avatar
orihime0
Regular Visitor
1 year ago

As posted above, they are related to eachother through the Item Relation table: