Measure calculate with filter

[bchouinard]

Hi,

I have created a measure like this one.

Avg =Calculate(AVERAGE(Table1[column1]),Table1[column2]="SpecificWord",SEARCH("containword1",Table1[column3],1,0)||SEARCH("containword2",Table1[column3],1,0)

and this works fine but I am wondering if it is possible to use a variable instead of hardcoding 'containword1 and 'containword2 for the search?

Thanks 

[v-qiuyu-msft · Accepted solution]

Hi @bchouinard,

Yes, you can define variables to return 'containword1 and 'containword2' and used in the Search() function. But you need to define two variables. The modified measure like below:

Avg = var v1="ca"
          var v2="ro"
    return 

Calculate(AVERAGE(Table1[column1]),Table1[column2]="SpecificWord",SEARCH(v1,Table1[column3],1,0)||SEARCH(v2,Table1[column3],1,0)

Best Regards,
Qiuyun Yu