Is it possible to find simmilar values between visuals?

[Byte_me]

Hello, all!

I have extremly large data set - 500k rows with 30+ columns. For the sake of this question let's assume that I need to use only two columns: Material_Name and Amount.
Material_Name is text, Amount is number (including values below zero)

I want to create Table1 (as visual) that will display me Material_Name and Amount (only values above 0)

And I want to create second Table2 (as visual) that will display me Material_Name and Amount (only values below 0).

Now, when I click on certain Material_Name in Table1 (visual) i want to be able to look for simillar names in Table2 and display them.

Is it possible?

My issue is that when Material is being replaced, it's Material_Name is not the same. It has arround 0,8-0,9 name simmiarity because Master Data owners change just couple of last letters.

[v-eachen-msft]

Hi @Byte_me ,

You could try LEFT() or RIGHT() function to truncate strings and compare them.

[Byte_me]

maybe there is a function that will look for similar string? Not exact match

[Byte_me]

I don't know what how many letter are being attached. So Left() or right() function does not find use in my case.

But how can I compare them? I can't do it binary (exact match) I'm looking for something like fuzzy matching on visual level. Or fuzzy matching after user will pick filters and limit the data

[v-eachen-msft · Accepted solution]

Hi @Byte_me ,

You could try split.

You could get a number column and a text column. Then you can match the number part.

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Not a ton of options in DAX for things like this, SEARCH, FIND. You will have to make sure that the visuals do not cross filter or otherwise filter each other. Could possibly create a table with the unique common names, that might help but tough to be sure without sample data.