Lookup function error

[VenkatTav]

Hi Team,

I have a requirement to show all the description names based on code, but am getting the below error.

Error message:

Description	Code
Tx	207
DC	207
NY	207
LS	207

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but please try something like below.

If the requirement is to show all the description names, CONCATENATEX DAX function might help.

LOSS_MIT_STS_ShowAll =
CONCATENATEX (
    FILTER (
        SERVICE_REFERENCE_DETAIL_VW,
        SERVICE_REFERENCE_DETAIL_VW[CODE] = "207"
    ),
    SERVICE_REFERENCE_DETAIL_VW[CODE_DESCRIPTION],
    ", "
)

[VenkatTav]

Apologies , Let me be clear then , I have a table (EX :A) which stores information of the codes and respective descriptions example i pasted table above. and I also have another table (EX:B) and i need to bring only descriptions in to table B , as my model do not have join between A&B tables i am creating a new column in table B and using above calc lookup function to get description using lookup code.