Channel: Leila Gharani

Category: Education

Tags: calculate functionmicrosoft excel tutorialsexcel for analystsxelplusvisadvanced excel tricksxelpluscrossfilterpower pivot daxpower bi daxmany to one relationshipdaxexcel tips and tricksdata modellingpowerbimicrosoft excelrelated functionpower pivotpowerpivotleila gharaniexcel 2016excel 2019microsoft 365excel 2013excel online courseexcel 365power bi calculate

Description: Relationships in Microsoft Power BI and Power Pivot give us the ability to report on fields from multiple tables in the data model. The most common type of relationship used in data models is a One-to-Many Relationship. But sometimes you have to go from the Many side to the One-Side of the Relationship. I'll show you 3 different solutions you can apply in DAX. You can use these techniques in Excel Power Pivot and in Power BI as well. The first technique takes you through the DAX CALCULATE function and shows a trick you can use to get the filter flow the other way. I'll also demonstrate how the many to one side calculation works by breaking down the measure in simpler calculation steps so you can visualize and understand the process and how DAX performs the final calculation. 🌍 My Online Excel Courses ► xelplus.com/courses 00:00 Calculate with Many-One Relationships 00:22 Many-to-One Relationships In data models 02:11 The Wrong Approach 03:41 Solution 1: Using DAX CALCULATE 06:36 Solution 2: Adding a Column On Many-Side RELATED 07:36 Solution 3: Using CROSSFILTER 09:28 Wrap Up ⯆ DOWNLOAD the workbook here: xelplus.com/dax-many-to-one-side-calculations 🎬 LINKS to related videos: - Excel Productivity for Lazy (but Smart) People: youtu.be/Gf4HmkR7_FE - DAX CALCULATE Function Made Easy to Understand: youtu.be/40xO1MD_CCs 🎒 Get the Official XelPlus MERCH: xelplus.creator-spring.com 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz 📚 Excel RESOURCES I Recommend: xelplus.com/resources 🎥 GEAR I use: xelplus.com/resources/#gear More resources on my Amazon page: amazon.com/shop/leilagharani 🚩Let’s connect on social: Instagram: instagram.com/lgharani Twitter: twitter.com/leilagharani LinkedIn: at.linkedin.com/in/leilagharani 👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #MsExcel #powerbi #dax