Search in text and sum values measure

[badger123]

Hi all, looking for help with a measure please... 

I have measure (see below) which is searching for a given term in phrases in another table. I am displaying the output in a table visual with term as column 1 and count of term as column 2. I'd like to create a measure that sums up the phrase volumes. I've included tables and desired output below. 

Measure1 = 
VAR CurrWord =
SELECTEDVALUE ( 'Table1'[term] )
RETURN
COUNTROWS (
    CALCULATETABLE (
        VALUES ( Table2[phrase]),
        FILTER ( Table2
        , SEARCH ( CurrWord, Table2[phrase], 1, -1 ) > 0 ) ))

Table1

Term

apples

oranges

bananas

Table2

Phrase	Phrase Volume
I like apples and oranges	100
I do not like bananas	200
I love apples the most	300

DESIRED OUTPUT TABLE VISUAL:

Term	Measure 1	Measure 2?
apples	2	400
oranges	1	100
bananas	1	200

[LivioLanzo · Accepted solution]

@badger123 

you are nearly there, instead of doing

COUNTROWS (
    CALCULATETABLE (
        VALUES ( Table2[phrase]),
        FILTER ( Table2
        , SEARCH ( CurrWord, Table2[phrase], 1, -1 ) > 0 ) ))

you can do

calculate(sum( Table2[phrase volume]),
        FILTER ( Table2
        , SEARCH ( CurrWord, Table2[phrase], 1, -1 ) > 0 ) ))

[badger123]

Thanks for your help! It seems so easy when you know the answer 😛