Forum Discussion
Problem with USERELATIONSHIP
Hello, I'm seeing an issue when using a DAX measure with the USERELATIONSHIP Function to activate an inactive relationship. The formula is: FY21(YTD) Count = IF(ISBLANK(SELECTEDVALUE(OrgMap[Le...
Hi Anonymous
I can see your data so not able to write a dax, but you need to use HASONEVALUE in your code.
https://www.sqlbi.com/articles/distinguishing-hasonevalue-from-isinscope/
https://docs.microsoft.com/en-us/dax/hasonevalue-function-dax
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!