Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Kishore_ak
Frequent Visitor

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

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.

Kishore_ak_0-1672574444617.png

Kishore_ak_1-1672574465937.png

Kishore_ak_2-1672574538452.png

 

 

2 ACCEPTED SOLUTIONS
Jihwan_Kim
Super User
Super User

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.

 

Jihwan_Kim_0-1672575439030.png

 

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

 

 


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

View solution in original post

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.

 

Jihwan_Kim_0-1672628009253.png

 

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

 


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

View solution in original post

6 REPLIES 6
Kishore_ak
Frequent Visitor

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. 

Kishore_ak_0-1672593151323.png

 

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.

 

Jihwan_Kim_0-1672628009253.png

 

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

 


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

great! Thanks alot for the support.

Jihwan_Kim
Super User
Super User

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.

 

Jihwan_Kim_0-1672575439030.png

 

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

 

 


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

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:

IDRun1Run2Run3Machine Number
YE144367711
HJ351621712
RT569012713
HJ334545714
BN5565278715
YE1798990716
HJ3232343717

 

Table with New Column:

IDRun1Run2Run3Machine NumberNew Column
YE144367711716
HJ351621712714,717
RT569012713None
HJ334545714712,717
YE1798990716711
HJ3232343717712,714

Thank you for the help.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.