Forum Discussion
Problem with LOOKUPVALUE not returning all values
From your formula it seem like you are asking for a value of the column "ID' in the table "Kunde" where the value of the column "ID" in the table "Kunde" is equal to a value in the column "Kunde ID" in the table "Angebot", so you are basically asking it to return the ID with you already have in your table.
You should change your formula so the first parameter points to the colunm in the table "Kunde" that has the customer name and not the customer ID.
If there is no match that satisfies all the search values, a BLANK is returned. In other words, the function will not return a lookup value if only some of the criteria match.
Hi,
I did that with intent.
What I want to show is that if you look at the guids [Kunde ID] in the quote table they are four times the same.
But the lookupvalue returns only two times a value from the Kunde[id] column (which is of course the same as the Angebot[Kunde ID] value.
I would expect to have four times a return value?
Why are two others empty?
They have the same value?
I agree that to the named eye they look identical, but sometimes data consist of hidden values, but lets try another formula
CALCULATE( VALUES ( Kunde[ID] ); FILTER ( Kunde; Kunde[ID] = Angebot[Kunde ID] ) )