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" } )
    )
    )
    )

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi Anonymous 

try like:

IF(
    COUNTROWS(
        FILTER(
           FACT PO,
           AND(
              NOT FACT PO[PO TYPE] IN{"INT", "IN2"},
              FACT PO[STATUS] IN {10, 15, 31}
            )
        )>0, 1, 0
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    HI Freeman,

    thanks for your swift response, appreciate it!

    Unfortunately i get an error messag: syntax or semantic error: at line.... Too many arguments were passed by the COUNTROWS Function. The maximum argument count for the function is 1.

    Any alternatives?

    thanks!!

    M