Forum Discussion

jesusssss's avatar
jesusssss
Icon for Helper II rankHelper II
3 years ago

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

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 cal...
Need Help
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

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's avatar
jesusssss
Icon for Helper II rankHelper II
3 years ago

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's avatar
    anands06
    Frequent Visitor
    2 years ago

    Hello,

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

    regards