Need help with relating two tables with the same column for dropdown filtering in Power B

[jesusssss]

Hi there, I'm having an issue with trying to relate two tables that have the same column.

I have a table called "Material entradas" that has a "provider" column, and then I have another table called "prueba" that also has a "provider" column. I want to relate these two columns so that I can create a dropdown and filter the data by provider, and have two independent measures from each table show up.

When we filter by any provider, we want both measures, which are independent from each table, to change.

These are the measures:

Measure 5 = COUNT('no conformidad proveedor'[ref])

Measure 6 = COUNT('18-Material entradas'[Ref])

We tried to relate them using a many-to-many relationship, but it didn't work.

Thank you very much for your help.

[johnt75]

Create a provider dimension table with the unique values from both tables. You can either do this in power query or in DAX like

Providers =
DISTINCT (
    UNION (
        DISTINCT ( 'prueba'[Provider] ),
        DISTINCT ( 'Material entradas'[Provider] )
    )
)

Create one-to-many relationships from this new table to both fact tables and then use the new column in any visuals, filters or slicers.

[jesusssss]

Hi @johnt75 

I have already tried the method you told me and it has joined the two provider tables correctly

but when I try to relate them from one to many, it doesn't let me and it gives me this error.

Thanks for the help 

[anands06]

Hello,

Were you able to find the solution, I am having a similar issue on my side.

regards