Answering questions: another option for many to many relationships in Power BI - Unplugged #39
HTML-код
- Опубликовано: 17 дек 2021
- Analyze and measure the performance of an alternative data modeling solution suggested by Daniel Otykier (author of Tabular Editor) regarding the article Different options to model many-to-many relationships in Power BI and Tabular (www.sqlbi.com/articles/differ.... Which solution is faster? Or "it depends"? Watch the video to see the answer!
Read more about the "unplugged" format: www.sqlbi.com/blog/marco/2021...
#unplugged 
Наука
![Eminem - Tobey (feat. Big Sean & Babytron) [Official Audio]](http://i.ytimg.com/vi/9xn0OHEZZ8Q/mqdefault.jpg)
What a great approach to model Many-to-Many. Thanks Alberto
Great share, very very clear!!!
Love when an ‘out of the box’ idea increases both performance and our possibilities :) thanks for sharing!
Didn't think of doing it this way after your previous video but to make a one to many relationship between sales and customer inactive and to use it with a switch statement depending on filter applied.
Daniel's solution is definitely simpler to implement, more elegant and inactive relationship can be done as you explain.
Well done for the follow up. Thank you
Loved discussion at 17:00 to get best of both worlds.
This is just a flawless gem now
fantastic... love that there are more than one approaches, we just have to play! test! collaborate. thanks for another great video.
Fantastic! Even tho you are already DAX expert but you still keep on learning!
So in short, this should be good for all scenarios?
This was the first thing that came to my mind after seeing your previous video
IMO I think you should leave the sports Table in Limbo, why would you try to involve all the other tables which would run more efficiently on their own. Argo, I would rather stick to canonical
Though great to know different methods of achieving the same, the Inactive Idea was great, Thanks!
Great!
This also takes care of my concern with the new model having problems with customers playing no sport and losing the connection with sales.
Yeah but now you have a new problem - customers with no sales won't allow a CustomerSport relationship to work as they have to traverse sales. It's the same problem that just involves another table now. The given workaround to this with an inactive relationship and having to use USERELATIONSHIP calls to activate it isn't something I would want to introduce as a standard way of modelling many to many relationships.
Ciao Alberto! Saturday morning coffee and Sql bi, what more could one ask for?
My thoughts exactly. By coincidence I woke up in the middle the night and started re-reading the definitive guide.
Sometimes using a fact table as a real bridge is the only option. And bidirectional relationships :(
I mean cases when we build models with a lot of dimensional tables and a calendar. They produce so many crosses of dimensions .... because of business requirements to filter visuals.
Wonderful
Fascinating 🧐
10xxxx
Lol at 5:40 on Tabular Editor 3 snark to Daniel