Relationship from two columns string (instring sql like)

[danilomorganti]

Hello All!

I need your help about relationship from two table.

In  this table I have a similar column called TEXT_KEY (it is a concatenate of string) and I would like to create a relationship from table 1 to get data from table 2.

Is possibile to use Fuzzy function to create only relashionship?

Is there a way to create a SQL "like" relationship?

Many Thanks!

[danilomorganti]

Hello! You can find below a example of data

In a report I have a pareto with column WC and column VALUE from Table 1 and pareto with column CAUSES and column VALUE from tabel 1.

I would like when I click on pareto filter the table 2 based on column used in pareto.

If a I click on the first pareto, table 2 must to be filtered on colum WC, if I click on the second pareto, table 2 must be filtered on column CAUSES.

How can I do this type of automatic filter?

Many Thanks

[v-kelly-msft]

Hi @danilomorganti ,

Would you pls provide the sample data with pareto inside?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[danilomorganti]

Thank you for your answer!

What I want is, when I click on the chart of table 1 if in table 2 there are some corresponding it populates a table view.

[v-kelly-msft]

Hi @danilomorganti ,

Can you make some screenshots as examples to make the requirement more clear?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[mahoneypat]

You can do a fuzzy merge in the query editor, but not on the DAX side.  You could approximate it using FILTER and SEARCH, CONTAINS, LEFT, etc., if the two columns differ in a similar way.

Regards,

Pat