Search and get Multiple partial match results for each row using DAX

[Kishore_ak]

Hi

I am trying to search all partial matches for each value of one table from another table.  Can someone help me in te below.

Thank you.

 

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

It is for creating a new column in the Search table.

Partial match IDs CC =
CONCATENATEX (
    FILTER ( Source, CONTAINSSTRING ( Source[Name], 'Search'[Name] ) ),
    Source[ID],
    "; "
)

[Kishore_ak]

Hi @Jihwan_Kim Is it possible to inlude an additional condition like below. 

concatenation should happen only in case of their MIDs are matching. Thank you in advance. 

[Jihwan_Kim · Accepted solution]

Hi,

Thank you for your message.

I do not know how your data model looks like, or how the relationship is created, but I assume there is no relationship between two table.

Please check the below picture and the attahced pbix file.

Partial match IDs CC = 
CONCATENATEX (
    FILTER ( Source, CONTAINSSTRING ( Source[Name], 'Search'[Name] ) && Source[MID] = 'Search'[MID] ),
    Source[ID],
    "; "
)

[Kishore_ak]

great! Thanks alot for the support.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

It is for creating a new column in the Search table.

Partial match IDs CC =
CONCATENATEX (
    FILTER ( Source, CONTAINSSTRING ( Source[Name], 'Search'[Name] ) ),
    Source[ID],
    "; "
)

[dmf]

Hi I'm having a similar query but without the option for a seperate Search Table.

Instead, I want to search the Source[ID] column against each value in the same column, Source[ID].

Essentially I want to search the Source[ID] column for repeats and then paste the data from an adjacent column Source[Machine Number] for those matching rows in concatenated form.

Thank you for any help!

Original Table:

ID	Run1	Run2	Run3	Machine Number
YE1	4	43	67	711
HJ3	5	16	21	712
RT5	6	90	12	713
HJ3	3	45	45	714
BN5	56	52	78	715
YE1	79	89	90	716
HJ3	23	23	43	717

Table with New Column:

ID	Run1	Run2	Run3	Machine Number	New Column
YE1	4	43	67	711	716
HJ3	5	16	21	712	714,717
RT5	6	90	12	713	None
HJ3	3	45	45	714	712,717
YE1	79	89	90	716	711
HJ3	23	23	43	717	712,714

[Kishore_ak]

Thank you for the help.