i have a table , which has two columns id and text. This is what data i have:
| id | text |
|---|---|
| 765 | hi how are you |
| 876 | John made $57. |
| 743 | apple is my favourite fruit. |
| 435 | mango is not my favorite fruit. |
| 892 | this is my favourite movie |
I have input column as slicer,in which i can choose any one id.for eg: 743
-765
-876
-**743**
-435
-892
I need the output, in which it would show the id ,text,text similarity score(score of how much similar two texts are like cosine similarity or fuzzy logic, see sample https://community.powerbi.com/t5/Desktop/Levenshtein-String-Distance-Algorithm-In-DAX/m-p/959772#M459838) of the selected id from slicer with all the other ids:
| id | text | score |
|---|---|---|
| 743 | apple is my favourite fruit. | 1 |
| 765 | hi how are you | 0.93 |
| 876 | John made $57. | 0.80 |
| 435 | mango is not my favorite fruit. | 0.70 |
| 892 | this is my favourite movie | 0.54 |