Forum Discussion
Solved
Returning a value based on a search range
Hi, I am looking for your help finding out the DAX formula to create the following scenario. thank you Name Country New Column AA XX if AA has XX in country column, then retu...
Please see if the following DAX resolves your issue:
Column = CALCULATE ( MAX ( [Country] ), ALLEXCEPT ( Countries, Countries[Name] ) )
rajulshah the result is not as expected. I want to get XX, if it exists in the whole range of countries for Name=AA
so for each name, the formula should look into the whole range of country column, and if XX is found at least once, then return XX.
AA might have multiple lines, however in the country column it is either XX or others. So I want to do a kind of search, and if XX is found once, then return XX
Please see if the following DAX resolves your issue:
Column =
CALCULATE ( MAX ( [Country] ), ALLEXCEPT ( Countries, Countries[Name] ) )