Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors