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

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

Thank you so much, this worked 🙂