Forum Discussion

ChrisO's avatar
ChrisO
Icon for Advocate I rankAdvocate I
10 years ago
Solved

Problem with LOOKUPVALUE not returning all values

Hello,   I have a datamodell from Dynamics CRM. I need to filter for example quotes based on dates and customer. My active relation is between quote and a datetable. No I want to add a custom co...
  • sdjensen's avatar
    sdjensen
    10 years ago

    ChrisO - Do you have a relationship from Angebot[Kunde ID] and Kunde[ID]? Did you make any transformation to any of the 2 columns since loading them from your source - change type etc. ?

ChrisO's avatar
ChrisO
Icon for Advocate I rankAdvocate I
10 years ago

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?

sdjensen's avatar
sdjensen
Icon for Solution Sage rankSolution Sage
10 years ago

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] 
	)
)
  • ChrisO's avatar
    ChrisO
    Icon for Advocate I rankAdvocate I
    10 years ago

    Still the same.

    The Kunde[ID] column is unique.

    • sdjensen's avatar
      sdjensen
      Icon for Solution Sage rankSolution Sage
      10 years ago

      ChrisO - Do you have a relationship from Angebot[Kunde ID] and Kunde[ID]? Did you make any transformation to any of the 2 columns since loading them from your source - change type etc. ?

      • ChrisO's avatar
        ChrisO
        Icon for Advocate I rankAdvocate I
        10 years ago

        sdjensen Eric_Zhang

         

        I just startet to strip down my datamodel to give you the file.

        During that process I deleted all relationships in the model.

        Now my missing values popped up.

         

        I don´t really understand what was wrong but now I know that something in model was wrong.

         

        Thank you for your help guys!

    • Eric_Zhang's avatar
      Eric_Zhang
      Icon for Microsoft Employee rankMicrosoft Employee
      10 years ago

      ChrisO

       

      Are there any invisible characters in that column? For example a leading line breaker, you can't find it just by looking. How many distinct values does it show when Kunde ID is selected?