Forum Discussion

jack3's avatar
jack3
Microsoft Employee
6 years ago
Solved

Filter two separate data sets using one filter

I have two data sets and I want to be able to filter them using one filter. Both data sets are seperate and there is no unique indentifier that can be used to create a relationship between the two ta...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    jack3 , Do you have common tables for those, if not create common tables.

    The first one should work ideally, But in the new version, it is not, so try one of the three. It gives circular dependency error

     

    new table like

    product = distinct(union(all(Dataset1[Product]),all(Dataset2[Product])))
    product =distinct(union(distinct(Dataset1[Product]),distinct(Dataset2[Product])))
    product = summarize(union(distinct(Dataset1[Product]),distinct(Dataset2[Product])),[Product])

    Create for others too and join and the analyze with common dimesion

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI jack3,

If your dataset relationship is based on multiple fields, you can also take a look at the following blog to know how to build a relationship between multiple columns:
Relationship in Power BI with Multiple Columns 

Regards,

Xiaoxin Sheng