Forum Discussion

Alanbo's avatar
Alanbo
Frequent Visitor
7 years ago
Solved

Relationship doesn't work towards 4th table

Hi, 

 

I have a minor issue with one of my reports.

I have 4 tables connected through relationships, but only one link between each of them.
But the data between the 1st and the 4th table is not dynamic. how do i connect these tables?

Connecting the 1st " 04 FunctionTargets" and the 4th "08 Scrap reason codes" doesn't seem to solve the issue 

 

Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, Alanbo 

    1. If you want to the data between the 1st and the 4th table is dynamic,

    you should keep all the cross filter direction is "Both"

    2. for your data model, 10 and 08 is dim fact table and 04 and 07 are data table, the best data model should like this:

    Then use all the dim fields from10 and 08 tables in visual and for filter.

     

    Best Regards,
    Lin

2 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    hi, Alanbo 

    1. If you want to the data between the 1st and the 4th table is dynamic,

    you should keep all the cross filter direction is "Both"

    2. for your data model, 10 and 08 is dim fact table and 04 and 07 are data table, the best data model should like this:

    Then use all the dim fields from10 and 08 tables in visual and for filter.

     

    Best Regards,
    Lin

    • Alanbo's avatar
      Alanbo
      Frequent Visitor
      7 years ago

      Hi, 

      Thank you, I have it working now