Forum Discussion
Measure calculate with filter
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
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"
returnCalculate(AVERAGE(Table1[column1]),Table1[column2
]="SpecificWord",SEARCH(v1,Table1[colu mn3],1,0)||SEARCH(v2,Table1[column3],1 ,0) Best Regards,
Qiuyun Yu
1 Reply
v-qiuyu-msftCommunity Support
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"
returnCalculate(AVERAGE(Table1[column1]),Table1[column2
]="SpecificWord",SEARCH(v1,Table1[colu mn3],1,0)||SEARCH(v2,Table1[column3],1 ,0) Best Regards,
Qiuyun Yu