Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

RELATED function not pulling all values

I have a two identitical data set that have ID numbers that are reoccuring in the data sets. I have used the CONCATENATE function to bind this value together with another code that creates a unique r...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Thanks for your reply. 

     

    I resolved the matter by creating a DIM table without active relationship and using USERELATIONSHIP instead

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi Anonymous ,

 

Based on your shared sample pbix file, The "CONCATENATED text string for 1:1 Relationship" Column does not have the same value, for example "15-1-19-1" and "15-3-19-1" , although the two tables has a One-One relationship, but it only connect the rows which have same value in CONCATENATED column.

 

Have you tried to create a M:M relationship between two tables based on the "ID NO" column? Could you please  show the exact expected result based on the Tables that you have shared.


Best regards,

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for your reply. 

 

I resolved the matter by creating a DIM table without active relationship and using USERELATIONSHIP instead

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Glad to hear that you have resolved your problem. Thank you for sharing this wonderful solution, would you please kindly mark your sharing solution as an answer so that it can benefit more users?


    Best regards,