USERELATIONSHIP to retrieve data through different relationship

[lomyk]

Hi there, 

I would greatley appreciate if someone can suggest any ideas.

I need to genreate a list of proerties (from property table) and assgin (in the same column) different Business Units (from Business Unit table) using 2 different relationships (red and blue below). I don't need to do any agregations, just a column of property id and its realted businessunit.

Any ideas? 

Thank you very much 

[v-sathmakuri]

Hi @lomyk ,

May I ask if you have resolved this issue?If the issue is not resolved , please provide more details on the requirement to provide better solution.

Thank you!!

[v-sathmakuri]

Hi @lomyk ,

May I ask if you have resolved this issue?If the issue is not resolved , please provide more details on the requirement to provide better solution.

Thank you !!

[v-sathmakuri · Accepted solution]

Hi @lomyk  , 

May I ask if you have resolved this issue?If the issue is not resolved , please provide more details on the requirement to provide better solution.

If your issue is resolved, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[lomyk]

Hi Ashish, thank you for looking into my question. What I want to achive is a list similar to the below scrrenshot. To be more accurate, I'm using this this semantic model to create a paginated report where I need these fields to talk properly and display the whole list made out of 2 columns: properties which have a Business Unit value coming via blue line and properties which have a Business Unit value coming via red line. Properties are coming from same table named Property. At the moment, my list is not full, as dispalys values that have a Bussiness Unit value coming via red line only. I created 2 separate measures (second below screenshot ) where  I can count all properties separateley on each way using USERELATIONSHIP to activated blue direction. My problem is that I don't need to aggregate them, just need the full column of poperty codes from Property table and unde Business Unit column to have values to come from different sides at once. Is that even possible? 

Thank you so much 

[Ashish_Mathur]

Hi,

There is nothing i can understand from those screenshots.

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result very clearly.