Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Looking for filter

Hi all,   I am troubling a bit with a way to find a filter. My table does look like this: MainID ID Name Catalog 1 22 abc 200 1 23 cde 201 1 24 efg 205 2 25 ghi 200 ...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

     

    Is this what you expected?

     

    Measure = CALCULATE(COUNTROWS('Table'),FILTER('Table',NOT [Catalog] IN {203,205}))

     

    Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

I have tried following, but it did not work yet:

CALCULATE(SUM(Table[Cutstomer.MainID]), (Table[Catalog] in {200, 201} && NOT Table[Catalog] in {203, 205}))

 

Any idea how to improve this?