two Slicers to filter values from two different tables

[logan_logan]

Lets say I have table 'Sales' and 'product'. In both the table has column 'Region', 'Name'. and they have similar attribute.

In the cucrrent view all the measures/cards are feeding from 'Sales' and slicers are also from this table. Now I need to get one measure in cards from Product table using the slicer Region & Name(both coming from Sales table) in the same view.

FYI, there is no unique row or not paossble to create. Also two tables are not compatibale to append/join/merge.

I joined two table on Region & Name column using 'many to many' (one ot one not possible).

one relationship work, but another relationship stays inactive. I need to work both simulatenously.

[oritam3210 · Accepted solution]

Hi @logan_logan,

It's not possible to establish more than one active relationship between the same two tables. However, you can work around this by creating a calculated column in each table, which concatenates the values from the "Region" and "Name" columns. After creating this new concatenated column, use it to establish the relationship.

It is good practice to hide this calculated column from user view to maintain a cleaner user interface.

CONCATENATE function example:

CalculatedColumn = CONCATENATE(TableName[ColumnA],TableName[ColumnB])

Good Luck

---------------------------------------------------------------------------------------------------------------------
If you find this helpful, kindly consider marking it as 'Accepted Solution.'
This action helps others quickly find a reliable answer!