Problems with field reference

[anonymous]

When I reference the client table to get the name of my client according to the ID that is stored in the table to which it is referenced it brings me all the clients listed and I don’t know why , it is the only field with which it does this.

What am I doing wrong?, as I mentioned in all the other fields that I have also linked the function does its job perfectly.

Thanks for your help

[dbaum]

You likely need to distinguish your references to the ID_Cliente columns from different tables. Try:

SELECT(Clientes[Nombre], [ID_Cliente] = [_THISROW].[ID_Cliente])

Also, depending on how and where you’re using this expression, you might be able to instead use simply:

[ID_Cliente].[Nombre]

[anonymous]

Many thanks!!! Works with the second one!!!