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.

ChiragGarg2512's avatar
ChiragGarg2512
Icon for Solution Sage rankSolution Sage
2 years ago

Anonymous Does the requirement ask for a filter or a slicer?

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Actually no, just trying to filter on those selected MainIDs. So I am looking for a clever formula.