How to create a custom table or Matrix table

Hi,

I recommend approaching this a bit differently. With these steps you can visualize the information you want quite well.
You can create a dimension table like this one:

and then use it to create relationships:

By doign this you can create the visual like this:
Use the dimension table for slicer and then just create two table visuals.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

Thanks ValtteriN  for the post, your post doesnt solve my issue, as my clients export the data to csv, they dont want 2 tables. 

If you have any better view other than table please suggest, where i can show them the difference in the dependency  against the ID's 

Hi Abbi ,
Here is the sample file with solution: https://www.dropbox.com/t/BBz5quuploWDDOAY

This is very similar to this post https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Compare-two-columns-from-2-different-tables/m-p/2328322#M58397
Already ansewed your query but looks like you forgot to mark my answer as accepted 🙂

You can use power query to generate a distinct table of all ID's as described in the other post.
Code for Table 1 & 2:

T(n) Dependancy = 
IF (
    HASONEVALUE ( Append1[ID] ), 
    CONCATENATEX (
        Table(n),
        Table(n)[Depedency],
        "," & UNICHAR(10)
    )
)

For "Owner" you just need to retrieve the VALUES of the culumn "Owner" as follows

Owner = 
IF (
    HASONEVALUE ( Append1[ID] ), 
    DISTINCT ( VALUES  ( Table1[Owner] ) )
)

Your report would look like this

Kindly requesting you to mark both solutions as "Accepted".
Thank you and have a great day