Using USERELATIONSHIP to Activate Inactive Relationships

By default, Power BI will only use the data column relating to the active relationships when using columns from multiple tables in your visuals. In this video, Angelica will show you how to use the DAX function, USERELATIONSHIP to activate inactive relationships to make your data analysis more meaningful.
👍 If you enjoy this video and are interested in formal training on Microsoft Teams, Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Angelica30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - pragmaticworks.com/pricing/
👍 Ready to buy now? Click this link to apply the code and subscribe now- prag.works/Angelica30
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2ujujsb5
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/
Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️CZcams: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
Email: [e-mail]
#PragmaticWorks

[@osPA78]

Straight forward! Thank you for putting this video together!!!!

[@geralddahl9159]

Thank you for this resource. 😃 Question RE 10'39" mark of video: How is it that the Quantity by Ship Date (729) is greater than the Sum of OrderQuantity? I've never worked in a context that tracked these sorts of values; I wonder if the 729 figure represents some items shipped over the course of 2012 Quarter 1 that were 'sold' in 2011? Thanks for sharing if my question makes sense LOL.

[@welcometomathy]

Hi I need help using inactive relationships. I have a calendar table with two values() tables of year from that calendar. I need to filter the years where there are spaces from the slicers using both those tables. The onde that is active works ok. The inactive one never gets filtered. Using normal sales from the facts or using sales with use related table. How can I get the value that don't return sales form the slicer using the year on the inactive relationship