cancel
Showing results for 
Search instead for 
Did you mean: 
0

UserRelationship and active relationship

Could somebody  help me understand userelationship? If I use userelationship in an inactive relationship between two tables. Will it overwrite the active relationship between the same two table? what does the overwrite mean? Does it mean make the active relationship inactive? Thanks!!

Status: Delivered
Comments
Moderator

@Ariahx,

DAX allows you to override the active relationship and use the inactive relationship in your formulas instead.  But it doesn't mean that make the active relationship inactive in Relationship view of Power BI Desktop. 

Please take a look at the following blogs about inactive relationship and USERELATIONSHIP .
https://exceleratorbi.com.au/multiple-relationships-between-tables-in-dax/
https://www.sqlbi.com/articles/userelationship-in-calculated-columns/


Regards,
Lydia

Moderator
Status changed to: Delivered
 
Occasional Visitor

Thanks!