Forum Discussion

nkasdali's avatar
nkasdali
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago
Solved

left relationship without merging

Hello, I have a question about the relationships between the tables in PBI. Example: Sales table: with year field (2017 & 2018) Calendar table: with the year field (2010 to 2018) Both tables h...
Need Help
Tips and Tricks
  • parry2k's avatar
    parry2k
    7 years ago

    nkasdali try cross filter direction to both where you setup the relationship.

anilb1603's avatar
anilb1603
New Member
3 years ago

Hi,
I have a similar requirement where I have 5 different tables in a model and I need to apply a filter to all the tables without using a merge. In qlik, we can simply use Left Keep which would take care of filtering. Looking for the same option in Power BI. Basically, my PBI model (tables) is connected through Order#. I need to apply the filter Order status = 'Active' in the first table which would give the active order#'s and then keep the same acive order#'s in all other tables in the model. I looked at some list filter options but not sure that's an efficient way to do this.

 

Any help would be appreciated.

 

Thanks