I was stuck for the reason why setting cross filter direction to Both yesterday night. After watching this video, you demonstrate an extremely clear example what situation is required for this setting and also the method to optimize this scenario to comprise performance issue and the setting. Thank you!
RADACAD, Thanks. Is it only when you are looking at count that you need the bi-directional? For example, even without the bi-directional relationship, table showing EnglishEducation & ProductKey seemed to work, but table showing EnglishEducation & Count of ProductKey didn't work (4:45 into the video).
so basically in the first example if you have create a measure sum(salesAmount) it would not have worked right? so it won't work only for any measures coming from the fact table ?
Great video, thanks a lot! But link to adventure works does not appear in the description and Microsoft already remove the link also. Is it possible you share this data base?, just in excel will be enough. Thanks again. Josep
![Blox Fruits Dragon Rework Update [Full Stream]](http://i.ytimg.com/vi/EqDAp8udhm0/mqdefault.jpg)
I was stuck for the reason why setting cross filter direction to Both yesterday night. After watching this video, you demonstrate an extremely clear example what situation is required for this setting and also the method to optimize this scenario to comprise performance issue and the setting. Thank you!
Glad it helped!
Thanks for this good explanation video. You are a good teacher. I study many things from your website.
Glad to hear that!
Great video! My favourite power bi channel!
Simple to understand and great explanation
Hi Rad, Very well explained video. Thank you.
Thanks for the video sir
Looking forward for video on data modelling
RADACAD, Thanks. Is it only when you are looking at count that you need the bi-directional? For example, even without the bi-directional relationship, table showing EnglishEducation & ProductKey seemed to work, but table showing EnglishEducation & Count of ProductKey didn't work (4:45 into the video).
so basically any measure from the fact table won't work... from what I have understand
Great video. Appreciate your share, Thanks.
so basically in the first example if you have create a measure sum(salesAmount) it would not have worked right? so it won't work only for any measures coming from the fact table ?
You deserve round of applause
Hello Rad,
Nice video with simple example.
I'm unable to download the xls posted in the description. Please help
Clear explanation 👌🏻👌🏻 thank you
Plz create data modelling video, this is very explainatory video
Great video thanks!
Thanks man, this was
Will I get the same problem in SQL Server or it will work just fine ?
یاشاسین اقا رضا
great explanation!
Thanks!
How do I manage this in Excel's power pivot? there is'nt the option to change the relationship's direction!!
Thanks brother .great explanation
thanks well explained, very professionnal !
Could you do a video about dax functions in Power BI ? Such as Sum SumX and calculate? This video has been very useful.
Will do for sure. Stay tuned
Great video! Thanks.
Great video, thanks a lot!
But link to adventure works does not appear in the description and Microsoft already remove the link also. Is it possible you share this data base?, just in excel will be enough.
Thanks again.
Josep
link added in the description now. Cheers
MVP genius.
Perfect
great video, but link doesn't work.