Forum Discussion

dw700d's avatar
dw700d
Icon for Post Patron rankPost Patron
5 years ago
Solved

One dimension table filters another dimension table

I am attempting to have one Dimension table filter another.I attempted to get the State table to filter the all locations table, Specifically I would like the location code column to be filtered by s...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    5 years ago

    Hi dw700d ,

    If you want to get the State table to filter the all locations table, you need to change the relationship between tables to Both. 

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

    Best Regards,
    Winniz

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-kkf-msft's avatar
v-kkf-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi dw700d ,

If you want to get the State table to filter the all locations table, you need to change the relationship between tables to Both. 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.