Error using RELATED, many to one / one to one

[elflakoconk]

Hi everyone, I've been looking for many posts without success.

I'm using DirectQuery with 2 tables:

The field key I'm using is "Telefono", the relation between both tables is many to one (many because 0 values repetead). So I need a new table in table A indicating the record where the value is the same in table B.

I've used RELATED getting this message: "The column 'B[Telefono]' either doesn't exist or doesn't have a relationship to any table available in the current context." 

I also tried changing the relation to one to one getting the same error.

Thank you.

[v-diye-msft]

Hi @elflakoconk 

Kindly check the attachment.

[elflakoconk]

Thanks for your time, but it didn't work, as I menttioned before, I need to use DirectQuery and using all the formulas described in others help answers it didn't work. It throws the same error message.

[v-diye-msft · Accepted solution]

Hi @elflakoconk 

It works in DQ connection mode, I tested it in DQ mode as well.

[amitchandak]

@elflakoconk , One of the Two should work

FLAG = ISBLANK(maxx(FILTER(B,A[Telefono]=B[Telefono]),B[Telefono]), "No", "Si")

FLAG = IF(ISBLANK(RELATED(B[Telefono])), "No", "Si")

[elflakoconk]

Thans a lot for your help.

using this: 

FLAG = ISBLANK(maxx(FILTER(B,A[Telefono]=B[Telefono]),B[Telefono]), "No", "Si")

Get this:

Too many arguments were passed to the ISBLANK function. The maximum argument count for the function is 1.

Also the autosense doesn't recognice the function FILTER and the B table.

for the second formula is the same first result.

😞

[mahoneypat]

So you tried an expression like this in your column?

NewColumn = IF(ISBLANK(RELATED(B[Telefono])), "No", "Si")

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat