Forum Discussion

ChrisO's avatar
ChrisO
Advocate 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. ?

sdjensen's avatar
sdjensen
Solution 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
Advocate I
10 years ago

Still the same.

The Kunde[ID] column is unique.

  • sdjensen's avatar
    sdjensen
    Solution 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
      Advocate 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
    Microsoft 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?