Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Custom Measure - Add Line "Does Not Contain" filter

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
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi Anonymous 

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

    will exclude all values that contains "O"

  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    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.

3 Replies

  • Daviejoe's avatar
    Daviejoe
    Icon for Memorable Member rankMemorable Member
    6 years ago

    Try

     

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

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Anonymous 

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

    will exclude all values that contains "O"

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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.