I like this video but in real world there are live connections to database and the relationships work quite different for live connections. Id be great to see a video on that too
Hey there, it introduces ambiguity to the direction of your filters, I dont think I've covered an example but here's a good article explaining this with an example: www.sqlbi.com/articles/bidirectional-relationships-and-ambiguity-in-dax/
Hi Rajesh, the Northwind db is something installed on my local machine, so you wont be able to connect to it. You'll need to install it on yours, here's the GitHub link to it: github.com/Microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs
Excellent - best explanation I've seen explaining why issues with table relationships occur and how to resolve them. Many thanks!
Wow.. I now understand relationship
Good to hear!
Thank you, you made it easy for me to understand
You are welcome, thanks for watching!
Thank you. Very helpful video.
I enjoyed this video. Post more complex modelling and how the flow happens.
5:10- the point of inactive relationships
I like this video but in real world there are live connections to database and the relationships work quite different for live connections. Id be great to see a video on that too
Thanks for this helpful video.
Short and sweet
What are the different tabs for in the relationships screen?
Thanks sir , cover of great topic,
Thanks for watching!
Can you show some example about possible issues/problems when both directional is selected, what could happen?
Hey there, it introduces ambiguity to the direction of your filters, I dont think I've covered an example but here's a good article explaining this with an example: www.sqlbi.com/articles/bidirectional-relationships-and-ambiguity-in-dax/
Good job my man
Thank you! 😃
Thank you
You're welcome
great work keep it up !
Thanks, will do!
I want to aply some DAX formulas two betwen the relation tables is that possible?
I don't see why not, just bear in mind how the relationships work and how the filter flows from one to another
thanks alot :)
You're welcome!
someone explain my doubt Product ID relationship between Products table and Order deatails table should be 1 to 1 And not 1 to many someone explain
Can you please provide the link for Northwind database and login details please
Hi Rajesh, the Northwind db is something installed on my local machine, so you wont be able to connect to it. You'll need to install it on yours, here's the GitHub link to it: github.com/Microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs
thanks Fernan I will check