El filtro NO CONTAINSSTRING no funciona.

[Syndicate_Admin]

Hola, quiero filtrar ciertas cosas que no contienen el valor dado en la medida pero no funciona.
Esta es mi medida:

Sum Incorrect Exec SG = 
CALCULATE (
COUNTROWS ( 'zhpla' ),
FILTER (
'zhpla',
('zhpla'[Position Assignment Category] IN {"Permanent ~ Executive","Contract Local DH ~ Executive","Expatriate Local DH ~ Executive" })
&& (NOT (CONTAINSSTRING ( 'zhpla'[Job Grade], "P1" ))
&& NOT(CONTAINSSTRING ( 'zhpla'[Job Grade], "P2" ))
&& NOT(CONTAINSSTRING ( 'zhpla'[Job Grade], "P3" ))
&& NOT(CONTAINSSTRING ( 'zhpla'[Job Grade], "P4" ))
&& NOT(CONTAINSSTRING ( 'zhpla'[Job Grade], "P5" ))
&& NOT(CONTAINSSTRING ( 'zhpla'[Job Grade], "P6" ))
&& NOT(CONTAINSSTRING ( 'zhpla'[Job Grade], "P7" ))
&& NOT(CONTAINSSTRING ( 'zhpla'[Job Grade], "G01" ))
&& NOT(CONTAINSSTRING ( 'zhpla'[Job Grade], "G02" ))
&& NOT(CONTAINSSTRING ( 'zhpla'[Job Grade], "G03" ))
&& NOT(CONTAINSSTRING ( 'zhpla'[Job Grade], "G04" ))
&& NOT(CONTAINSSTRING ( 'zhpla'[Job Grade], "G05" ))
&& NOT(CONTAINSSTRING ( 'zhpla'[Job Grade], "G06" ))
&& NOT(CONTAINSSTRING ( 'zhpla'[Job Grade], "G07" )))
) + 0
)

pero sigo recibiendo este error

¿Alguien puede ayudarme?

[Syndicate_Admin]

@zahidah_mabd

Gracias por contactarnos.

Puedes probar esto,

Sum Incorrect Exec SG test = 
CALCULATE (
    COUNTROWS ( 'zhpla' ),
    FILTER (
        'zhpla',
        ( 'zhpla'[Position Assignment Category]
            IN {
            "Permanent ~ Executive",
            "Contract Local DH ~ Executive",
            "Expatriate Local DH ~ Executive"
        } )
            && (
                NOT ( CONTAINSSTRING ( 'zhpla'[Job Grade], "P1" ) )
                    && NOT ( CONTAINSSTRING ( 'zhpla'[Job Grade], "P2" ) )
                        && NOT ( CONTAINSSTRING ( 'zhpla'[Job Grade], "P3" ) )
                            && NOT ( CONTAINSSTRING ( 'zhpla'[Job Grade], "P4" ) )
                                && NOT ( CONTAINSSTRING ( 'zhpla'[Job Grade], "P5" ) )
                                    && NOT ( CONTAINSSTRING ( 'zhpla'[Job Grade], "P6" ) )
                                        && NOT ( CONTAINSSTRING ( 'zhpla'[Job Grade], "P7" ) )
                                            && NOT ( CONTAINSSTRING ( 'zhpla'[Job Grade], "G01" ) )
                                                && NOT ( CONTAINSSTRING ( 'zhpla'[Job Grade], "G02" ) )
                                                    && NOT ( CONTAINSSTRING ( 'zhpla'[Job Grade], "G03" ) )
                                                        && NOT ( CONTAINSSTRING ( 'zhpla'[Job Grade], "G04" ) )
                                                            && NOT ( CONTAINSSTRING ( 'zhpla'[Job Grade], "G05" ) )
                                                                && NOT ( CONTAINSSTRING ( 'zhpla'[Job Grade], "G06" ) )
                                                                    && NOT ( CONTAINSSTRING ( 'zhpla'[Job Grade], "G07" ) )
            )
    ) 
)+0

Saludos

equipo de soporte de la comunidad _Tang

Si esta publicación ayuda, considere Aceptarla como la solución para ayudar a los otros miembros a encontrarla más rápidamente.