CALCULATE and FILTER using a wildcard

[Anonymous]

Count = CALCULATE(count('TableName'[Transaction]),
										filter('TableName',
                                                'TableName'[TransactionIDString] = "djyv"
										)
										)   

Hi,

Please could you tell me how to change the above code to search for a wildcard? I've tried replacing "djyv" with "*djyv*" but that doesn't work.

I have lots of other conditions in the real formula so would like to keep the current formula structure if possible!

Thanks,

CM

[v-piga-msft]

Hi @Anonymous ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share some data sample and your desired output so that we could understand your scenario better and get the solution quickly.

Best Regards,

Cherry

[v-piga-msft · Accepted solution]

Hi @Anonymous ,

You could have a reference of this similar thread which has been solved.

If you still need help, please share some data sample and your desired output so that we could help further on it.

Best  Regards,

Cherry

[Anonymous]

Hi 

I am unsure how to do this directly in a measure. However, one way to get around this might be to include a column that uses "SEARCH" to look for the partial string and returns a true or false flag. You could then use this to drive your measure?

Thanks