Comparing TREATAS vs USERELATIONSHIP in Power BI

Here's a video showing you the difference between TREATAS and USERELATIONSHIP when creating DAX measures. I will go over the process of when and why we use each of those DAX functions.
Here are the links mentioned in the video:
Two Fact Tables For Same Dates Table - forum.enterprisedna.co/t/two-...
TREATAS Function - info.enterprisedna.co/dax-fun...
USERELATIONSHIP Function - info.enterprisedna.co/dax-fun...
Jarrett
**** Video Details ****
0:42 Enterprise DNA Forum query on two fact tables
1:16 TREATAS definition
1:37 USERELATIONSHIP definition
2:09 data model used with the fact table and date table
3:15 when to use TREATAS function
4:47 when to use USERELATIONSHIP function
**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ulti...
FREE - Power BI Resources - enterprisedna.co/power-bi-reso...
FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-...
Enterprise DNA Membership - enterprisedna.co/membership
Enterprise DNA Online - portal.enterprisedna.co/
Enterprise DNA Events - enterprisedna.co/enterprise-d...

[@RavenRock88]

Very good comparison. In general I am interested in performance on this topic. Which topics need a lot of performance and which ones save performance?

[@akshayachandrasekar8285]

Awesome! Good explanation!

[@EnterpriseDNA]

Hi Akshaya, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!

[@erictremblay7310]

Great video Jarrett, anyway to have the Power BI file so I can see and keep as a reference ?

[@jbbaxter04]

Any benefit to using one or the other as far as performance/load time?

[@yeraldo05]

One benefit that I encountered with Treatas instead of UseRelationship was in the Data Model View.
Once you start to build more complex models the "In active Relationship" can be a problem due the multiple connections with several queries.
As a rule a thumbs up, "Always keep you Data Model Simple".

[@RichardOliver]

So TREATAS also works when there are relationships, by the looks of it.

[@MAbdullah47]

At the end which one is better in performance?

[@EnterpriseDNA]

Hello Mohammad,
Thank you for posting your query onto our channel.
Well, this video was created to highlight how you can create virtual relationships using "TREATAS" function whereas in case you've multiple in-active relationships then how you can use the "USERELATIONSHIP" function. This two functions just helps to create relationships and are mostly same in terms of performance.
Also if you want to learn more about the performance optimization we also have a course available onto our education portal which covers in-depth learning pertaining to the optimizations. We're providing a link from our TH-cam channel where one of our expert who created this course provides a glimpse of it as well as providing a link of the entire course from our education portal as well.
We're also providing few of the links of the articles from our blog posts as well as links of the videos from our Enterprise DNA TH-cam channel pertaining to this topic.
For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well.
Hoping you find this useful and meets your requirements that you've been looking for. Also, make sure that you're subscribed to our TH-cam channel so that you don't miss out on any updates pertaining to the Power BI.
Cheers,
Enterprise DNA
forum.enterprisedna.co/
th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
th-cam.com/video/M-qwYVmcdSU/w-d-xo.html
blog.enterprisedna.co/measure-in-power-bi-optimization-tips-and-techniques/
th-cam.com/video/NhSx1z-dP0M/w-d-xo.html
th-cam.com/video/E0lTc4m5-Tc/w-d-xo.html
forum.enterprisedna.co/t/how-to-optimize-debug-the-slow-reports-in-power-bi/8874
portal.enterprisedna.co/courses/enrolled/958368