Forum Discussion
Multiple Bridge Table Error
Why cant I show data in a table visual using multiple tables connected to a bridge table? So what I would like to happen is show columns in a table visual coming from different columns/tables co...
Hey,
what you are aksing for is not doable without creating measures or adjusting your model.
If you want to combine columns from different tables in a table visual, these tables have to be
- adjaccent, meaning directly related or
- indirectly connected by a "bridge" table where each table is one the one side and the "bridge" table is on the many side, but using the term "Bridge" table in this context is misleading
Maybe this blog post of mine gets you started:
https://www.minceddata.info/2018/03/16/to-treatsas-or-not-to/
Hopefully this gives you an idea
Regards
Tom
Can you give me the measure or calculation in order to achieve this? I would really appreciate it. Thanks
Hey,
please share a pbix file containing sample data, but all relevant tables and proper relationships. Upload the pbix file and share the link.
Please provide more details about the Business Problem that you want to tackle with your solution.
Regards
Tom
