Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Filter NOT and Include.

hi, in Cognos i have a filter that looks like this: Fact_PO NOT([PO Type] includes ("INT", "IN2") AND [Status] includes ('10','15','31') In PBI webversion it is apparently not possible to make suc...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Anonymous 

    please try

    Measure =
    INT (
    ISEMPTY (
    FILTER (
    'Fact PO',
    NOT ( 'Fact PO'[PO Type]
    IN { "INT", "IN2" }
    && 'Fact PO'[Status] IN { "10", "15", "31" } )
    )
    )
    )

CNENFRNL's avatar
CNENFRNL
Community Champion
3 years ago

Syntax equivalent

Flag = 
1 - CALCULATE(
        ISEMPTY( Fact_PO ),
        NOT ( Fact_PO[PO Type] IN { "INT", "IN2" } && Fact_PO[Status] IN { 10, 15, 31 } )
    )
Anonymous's avatar
Anonymous
Not applicable
3 years ago

HI,

thanks for the swift response, appreciate it.

unfortunately the proposed statement genereates an error: 

syntax or sematic error at line.... Function CONTAINSROW does not support comparing values of type integer with values of type text. Consider using the VALUE or FORMAT function to convert one of the values.