Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Which performs better TREATAS or USERELATIONSHIP?

Hi Guys 


From a performance perspective which performs better  TREATAS or USERELATIONSHIP?


Kind regards


Resident Rockstar
Resident Rockstar

Frequent Visitor

Hi @Daryl-Lynch-Bzy 


Thank you kindly for the reply.

I have read through the articles they dont really answer my question.

Which I think I might be asking in an incorrect manner. 

What im really after is a function that replicates USERELATIONSHIP() but runs faster in a standard situation?


Kind regards


Hi @dvn_charles 


The usage and return value of the two functions are completely different. 


USERELATIONSHIP is generally used to activate the inactive relationship between fields in two tables, acting on the specific measure.
TREATAS returns a table that can be used to join two completely different tables with the same data structure.

Best for use when a relationship does not exist between the tables. If you have multiple relationships between the tables involved, consider using USERELATIONSHIP instead.


I don't think there is a function that does the same thing as USERELATIONSHIP. And this function doesn't seem to particularly affect the speed of the code. If you could be more specific about your problem.

More details in reference:

USERELATIONSHIP function (DAX) - DAX | Microsoft Docs

TREATAS function - DAX | Microsoft Docs


Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey

Resident Rockstar
Resident Rockstar

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.