Forum Discussion

AshDil's avatar
AshDil
Icon for Helper V rankHelper V
4 years ago

Want to show data from two tables

Hi, I have two tables as follows: Table-1: CATEGORY   ID        SALES A 101 150 B 102 230 C 103 400 D 104 780 A 105 300 B 106 200 C 107 100 D 108 150 E ...
Need Help
Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
4 years ago

Hi AshDil ,

 

Another question. Whay is the high-level column here - Category or ID?

I am trying to understand why relationship is on ID column, why not on Category column.

 

Also if you want relationship on ID column, then have a bridge table with Distinct ID column values. No point in creating an additional bridge table if you still end-up with many-to-many relationship.

 

Thanks,

Pragati

AshDil's avatar
AshDil
Icon for Helper V rankHelper V
4 years ago

Hi Pragati11 ,

High level column is Category. I am creating relationship based on ID because they are unique. But the problem in ending up in many:many relationship is some ID's are present in 2 or 3 categories (eg: 101 is present under Category A,B and D).

Please suggest me if any other way to do it.

Thanks,

AshDil.

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    4 years ago

    Hi AshDil ,

     

    I think I mentioned the way in my previous response itself.

    You will have to create a bridge table with distinct values of ID and then create a relationship with other 2 tables.

    In your slicer on report page, use ID from this bridge table for filtering. It should work.

     

    In case this doesn't work, then do share a sample pbix file by removing any sensitive data from the pbix file. You can do this by uploading it to Dropbox or you can use WeTransfer as well.

     

    Thanks,

    Pragati