 Hey guys, welcome to SSQD Tech Sushilni side and this is continuation of Power BI tutorial. So today we are going to see about the cross filter direction in the Power BI. So this is also very important while we are going to use the filters. So what it means and how we can do in the practical. So go to on the Power BI desktop and we will see in the practical. So this is the project by which currently we are working on. So here let's double click on any one of the relationship that we have created in the earlier videos. So here as you can see in the right bottom you can see the cross filter direction. Here we have single and both so we have only two options. So what it means if we select the single then it will filter the data only for dim product table to country says final table and it will not filter the data from country says final table to dim product table. So what it means if we use a filter and on that filter will use the product name from the country says final table and will apply that filter in the dim product table. So that will not work until unless we will make this filter direction as both. So if we will make the both then either we can choose the product name from the product table or we can choose the product name from the country says final table. So on that basis it will filter the data for the same if we will have two tables and directly we cannot communicate on that table. So we'll have a intermediate table and we'll join that two tables by using the intermediate table. So if we will not use the cross filter direction as both so data will not be filtered. On that case we have to make the cross filter direction as both. So this is all about the cross filter direction and here as you can see we have made this relationship active. So once we uncheck this checkbox and click on OK then instead of this solid line we will see a dotted line. It indicates this relationship is not active. So this is all about the make this relationship active and one more thing if we will create the relationship between two tables more than one then we can active only one at a time. For example let's do one thing let me just drag this product id and drop in the anywhere like sale person id. So here we can see we have two relationship between these two tables. Now double click on that and try to make this relationship active. So here we can see we will get an error. It says you cannot create the direct active relationship between these two tables and active set of indirect relationship already exist between these tables. So it means we have already this relationship that's why we cannot create that relationship active. So first of all let me delete that one after that we'll try to make the relationship that we have before make it active. So go to the property and here let me try to make it active now click on OK. So here it will be solid line. So now we have created this relationship. So now we have seen about the make relationship active. So guys I hope you have understand about the cross filter direction and make this relationship active when we can use it in the real time scenario. So thank you so much guys for watching this video. If you like this video please subscribe our channel to get many more videos. Don't forget to press the bell icon to get the notification of our newly uploaded videos. Thank you so much. See you in the next video.