Forum Discussion

kevhav's avatar
kevhav
Continued Contributor
7 years ago
Solved

Specify one path, when USERELATIONSHIP creates ambiguous paths?

Consider this model...   I want to write a measure such that setting a filter on DimA will filter FactX by using the DimA -> BridgeA-B -> DimB -> FactX path, instead of the direct DimA -> FactX...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    kevhav ,

     

    I have make a test but couldn't reproduce your issue, the USERELATIONSHIP() function works well on my side. This issue should be related with your original data. So if possible, could you please share some sample data? The relationship in my demo is as below:

      

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • kevhav's avatar
    kevhav
    7 years ago

    Interesting! Thanks for this reply, v-yuta-msft ... I cannot share my data as it is now, but I will do some more testing, and see if I can come up with a sample dataset that I can share. 

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

kevhav ,

 

I have make a test but couldn't reproduce your issue, the USERELATIONSHIP() function works well on my side. This issue should be related with your original data. So if possible, could you please share some sample data? The relationship in my demo is as below:

  

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

kevhav's avatar
kevhav
Continued Contributor
7 years ago

Interesting! Thanks for this reply, v-yuta-msft ... I cannot share my data as it is now, but I will do some more testing, and see if I can come up with a sample dataset that I can share.