Many to Many or Bridge Table in Power BI - What is preferred model. Let's explore! | PeryTUS - Power
HTML-код
- Опубликовано: 25 мар 2022
- #POWERBI #MICROSOFT #MICROSOFTPOWERBI #DAX #MICROSOFTPOWERBIDATAANALYSIS, #DATAANALYSIS, #BUSINESSINTELLIGENCE #BI #PERYTUS #DECIPHERYOURDATA #DATAMODELLING #MANYTOMANYRELATIONSHIP #CROSSFILTERDIRECTION #BRIDGETABLE
Data modeling is fundamental for extracting valuable insights from your data and simplifying complex DAX measures in Power BI.
Have you ever wondered about the concept of many-to-many relationships in your data model? Are you familiar with the concept of a bridge table? Do you find it challenging to determine when to use one over the other?
In this video, we will explore various data modeling techniques and address the following questions:
Which data model is the most efficient?
What adjustments are necessary for our measures?
When should we modify the cross-filter direction?
How does the chosen model impact our visualizations?
Join us in this insightful journey towards mastering data modeling in Power BI for more effective data analysis.
🌏: perytus.com/
✍: perytus.com/blog/
📞: perytus.com/contact/ Наука
Very nice. Thank you
Thanks
very nice explanation of multiple scenarios of many-many relationships and limitations of each approach.
Glad you liked it. Thanks for the feedback. Much appreciated!
The context transition in the SUMX function ist very well explained. Following a Kimball design, I wouldn't solve this requirement with a many to many relationship at all. You have a Book dimension, an Author dimension and a Month dimension, and based on the proportion factor you can load a fully aditive fact table at exactly this granularity with the help of Power Query. No many to many needed, no complicated measures needed.
Indeed that is always the best and no question or doubt around that but there are scenarios when that is not possible and then what? Anyhow, appreciate the feedback.
Totally agree, there are other scenarios where many to many designs make sense. I was just talking about this specific requirement. Even if you have patterns available, it's still an important skill to apply the right pattern to the right problem.
Thank you.
You're welcome! 🙏
Remarkable 👌 ..
Thank u😊
Most welcome 😊Glad you liked it 🙏
So wonderfull, Thank you !!
keep it up.. Your subs should grow quite rapidly
Thanks for the lovely feedback. Do share it with you network so that it can reach to the wider audience and lot more people can learn from it. Thank you!
why r u using max, btw thank you very much
Thanks for the feedback. Are you referring the _max_ used at 6:40ish?
@@PowerBIHowTo yes sir
@@PowerBIHowTo I too had that doubt. Since we are iterating via sumx in author, we can directly use the column instead of max(col) . also since rev is measure, it will convert rc to fc. Author Rev =
SUMX (
Author,
Author[Book Revenue Proportion] * [Rev]
) isnt
Hello sorry for getting back on this super late. Yes there is no need to use the _max_ since we are using _author_ table and have access to all the columns in that table for each row. I was working on a different model where it required _max_ and I missed changing the measure without _max_ . Thanks for pointing this out. Although I have another video to work on where _max_ will be required and try to have that out to clarify it further.
Cheers!!
Wouldn't be SELECTEDVALUE more appropriate than MAX if we know we expect exactly one value, so the measure doesn't accidentally return a value if something is messed up in the data?
Ssss
🙏