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

tamerj1's avatar
tamerj1
Community Champion
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" } )
)
)
)

Anonymous's avatar
Anonymous
Not applicable
3 years ago

hi Tamerj1

thanks for helping out, it seems to be working!!!!

well done.

Mrt