Forum Discussion

MvdL's avatar
MvdL
New Member
6 years ago

Add Topic and keyword to main table based on second table

Hello! Hopefully you can all help me, I have a main table with cells with large body of text, then I also have a second table with Topic and keywords fields. In the first table I want to create two ...
Need Help
MFelix's avatar
MFelix
Super User
6 years ago

Hi MvdL 

 

Based on the blog post below you can do a simiçar approach with a measure:

 

https://powerpivotpro.com/2014/01/containsx-finding-if-a-value-in-table-1-has-a-matching-value-in-table-2/

 

Add the following measure to your model:

Contains Selected Word = 
IF(
      SUMX(SUMMARIZE(Keywords;Keywords[Keywords]);
           FIND(
                UPPER(Keywords[Keywords]);
                UPPER(SELECTEDVALUE(Main[Text]))
                ;;0
               )
          ) > 0;
      "Contains Words Selected";
      Blank()
     )

 

Now you can filter out the visualization based on the slicer and the measure.

 

On the image below I have added the filter but only keep the the ones that the measure is not blank.

 

Check PBIX file attach.

  • MvdL's avatar
    MvdL
    New Member
    6 years ago

    Thanks! This works 🙂