How to filter/count with contains and any blanks as 0

[lennox25]

I have this measure but want to adapt is as what I am searching for markets is contained in the sentence. The measure below is fine for what I needed it for but doesnt work as markets is within a sentence. Can anyone help? Please? Thank you

No of  Batch = if(ISBLANK(CALCULATE(

COUNT('table'[ID]),

FILTER('table', table[category] = " Batch"))),0,CALCULATE(

COUNT('table'[ID]),

FILTER('table', table[category] = "Batch")))

[Anonymous · Accepted solution]

Hi @lennox25 

With reference to the information provided by you, I ran the following tests:

Here's my test data.

Then I created the following measure:

isBatch = FIND("Batch", SELECTEDVALUE('Table'[category]), 1, 0)

No of Batch = COUNTX(FILTER('Table', 'Table'[isBatch] > 0), 'Table'[ID])

Is this the result you expect?

Best Regards,

Community Support Team_Yuliax

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lennox25]

Thank you Very much 🙂