Forum Discussion

zahidah_mabd's avatar
zahidah_mabd
Helper I
4 years ago
Solved

NOT CONTAINS Measure not working

Hi, I want to filter value NOT CONTAINS the specified value but its not working   Mismatch Executive = CALCULATE( COUNTROWS('table'), FILTER( 'table', ('table'[Position Assignment Category] = ...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, zahidah_mabd 

    Please try formula as below:

     

    Mismatch Executive =
CALCULATE (
    COUNTROWS ( 'table' ),
    FILTER (
        'table',
        ( 'table'[Position Assignment Category] = "Permanent ~ Executive"
            || 'table'[Position Assignment Category] = "Int. Secondee PET ~ Executive" )
            && ( 'table'[Job Grade] <> BLANK () )
            && ( NOT ( 'table'[Job Grade] IN { "P1", "P2", "P3" } ) )
    )
) + 0

     

    Best Regards,
    Community Support Team _ Eason

zahidah_mabd's avatar
zahidah_mabd
Helper I
4 years ago

Can I use CONTAINS instead of CONTAINSSTRING?

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    4 years ago

    Hi, zahidah_mabd 

    Please try formula as below:

     

    Mismatch Executive =
CALCULATE (
    COUNTROWS ( 'table' ),
    FILTER (
        'table',
        ( 'table'[Position Assignment Category] = "Permanent ~ Executive"
            || 'table'[Position Assignment Category] = "Int. Secondee PET ~ Executive" )
            && ( 'table'[Job Grade] <> BLANK () )
            && ( NOT ( 'table'[Job Grade] IN { "P1", "P2", "P3" } ) )
    )
) + 0

     

    Best Regards,
    Community Support Team _ Eason