Forum Discussion
LOOKUPVALUE does not return all values
Community ChampionI believe this is by design:
https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax
Return value
The value of result_column at the row where all pairs of search_column and search_value have a match.
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.
If multiple rows match the search values and in all cases result_column values are identical then that value is returned. However, if result_column returns different values an error is returned.
Thanks Greg_Deckler
I also red that.. but for me the values are in fact diferent... I assumed that the behaviour was not the one you describe.
So..
A Filter/Calculate to get this one?
- Greg_Deckler
Are the 2 tables related? Seems like if you relate them ITEM[Previous Value] > GROUP[Status] that this problem becomes trivial. Or are these 2 tables already related some other way?
- Greg_Deckler
Even more perplexing, I implemented your formula as a Column in ITEM table and it worked perfectly, got all of the group names. This was with completely unrelated tables. So, I'm guessing that you do in fact have a relationship between the tables and that is what is messing with your formula.
Yep... bu I tried the same with a "new" table that withou relation and the result was the same...