Forum Discussion
PowerBI USERELATIONSHIP function used in a measure not working with an inactive relationship
Hi All, Hope everyone is doing fine. I am in the middle of a weird scenario and need help. Please see screenshot below that shows 3 different relationships, one active and two other as non acti...
In order to use USERELATIONSHIP function you must keep all the relationships 'In-Active', otherwise the existing active relationship will override the relationship you are trying to make using USERELATIONSHIP function. Try deactivating all relationships and use your first measure, it should give you expected result.
sm_talha
Resolver II
Resolver IIIn order to use USERELATIONSHIP function you must keep all the relationships 'In-Active', otherwise the existing active relationship will override the relationship you are trying to make using USERELATIONSHIP function. Try deactivating all relationships and use your first measure, it should give you expected result.
sm_talha thank you so much, that worked like a charm!