Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Missing relationship (probably with missig data)

Hey,

For a project i'm working on, i need to link location to an article.
I want to search in a text to find a part of code. Therefore i used the SEARCH() Function.

I used the RELATED() function to make an extra column that checks if the code string has the right location.

 

_LigtOpJuisteLocatie = SEARCH([Currect_ABC_CODE], RELATED('Locatie codering'[ABCDEJ waarde]),1,0)

 

 I get this error message :

This is the relationship between the tables ;

I rearranged the relationships multiple times but've no clue what to do next.

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    You put RELATED(...) in within part in search function. Due to relationship is many to many, I think this may cause error. I suggest you to try this code.

    Measure = 
VAR _LIST = CALCULATETABLE(VALUES('Locatie codering'[ABCDEJ waarde]),FILTER(ALL('Locatie codering'),'Locatie codering'[ColumnName] = 'ARF_Artikel_filiaal'[ColumnName]))
RETURN
IF([Currect_ABC_CODE] IN _LIST ,1,0)

     

    Best Regards,
    Rico Zhou

     

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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    You put RELATED(...) in within part in search function. Due to relationship is many to many, I think this may cause error. I suggest you to try this code.

    Measure = 
VAR _LIST = CALCULATETABLE(VALUES('Locatie codering'[ABCDEJ waarde]),FILTER(ALL('Locatie codering'),'Locatie codering'[ColumnName] = 'ARF_Artikel_filiaal'[ColumnName]))
RETURN
IF([Currect_ABC_CODE] IN _LIST ,1,0)

     

    Best Regards,
    Rico Zhou

     

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