Custom Measure - Add Line "Does Not Contain" filter

[Anonymous]

Hi,

I have a measure I've created that I need to slightly modify:

Admissions Per 1000 = DIVIDE(CALCULATE(DISTINCTCOUNT('ClaimData'[Metric ID.3]),

FILTER

('ClaimData','ClaimData'[Place Of Service] IN {"21", "31"}),

'ClaimData'[Admit Date] <> BLANK (),

'ClaimData'[Discharge Date] <> BLANK ()),

'Eligibility'[Member Months])*12000

I need to add an additional filter that essentially states that field [ICD10 Mapping] does not contain the letter O.  I've tried including this line:  'ClaimData'[ICD10 Mapping] <> "%O%" but it is incorrect since that states to exclude exactly "O".  The results I'm trying to exclude are such as "O48", "O91", "O11" etc.

Any ideas?

Thank you

[az38 · Accepted solution]

Hi @Anonymous 

SEARCH("O", 'ClaimData'[ICD10 Mapping] ,,0) = 0

will exclude all values that contains "O"

[v-easonf-msft · Accepted solution]

Hi , @Anonymous 

The "search "function is case insensitive. If you don’t require case sensitivity, you can try this function . When searching for "O" ,it will find the first occurrence of 'O' or 'o'.

If you  want to indicate whether one string contains another string. The "containsstringexact"  function will be a better choice.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[az38 · Accepted solution]

Hi @Anonymous 

SEARCH("O", 'ClaimData'[ICD10 Mapping] ,,0) = 0

will exclude all values that contains "O"

[Daviejoe]

Try

Left ( 'ClaimData'[ICD10 Mapping], 1 ) <> "O"