Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Creating a data table, using existing table columns with relationships


I am kind of stuck and I am quite new to PowerBI so any help will be much appreciated . Hopefully I can make sense with what I ask . I am currently trying to create a new data table based on this table visual attached below . The columns added are all from different tables that have a relationship with eachother. Is there anyway to create this as a data table ? I have tried to do this with the merge query function though I did have no luck. Any help will be much appreciated. Please any help would be greatly appreciated !!







Super User III
Super User III

Hi @andrew-26 ,


Just wanted to check on why the requireemnt is to create a new data table rather making use of relationships in Power BI and visualise the data in a table visual?

Also, you will need to add more details here. I can't understand much from the screenshot that you have shared.




If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Thanks for the reply @Pragati11  , that was initially my first thought is to create a measure, to calculate if a company is healthy or not. The aim for me is to create a measure which calculates the health of a compnay . This is decided if reports are turned on , notifications turned on and there is 2 or more users in a company , that company will be considered as 'healthy', sorry if that is confusing , this is also the best screenshot I can give I have to strike out company information , apologies



Hi @andrew-26 


You might consider providing your dummy pbix that would be helpful for us to investigate it further. 

You can upload it to the onedrive for business and share the link here. please don't forget to disclose the expected results and remove the confidential info.


Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more

Helpful resources


Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.


Power BI Women

Join our monthly meetings and learning sessions.



We are excited to announce the Power BI Super Users!


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors