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:

MainIDIDNameCatalog
122abc200
123cde201
124efg205
225ghi200
226ijk201
227lmn203
328opq200
329rst201
430tuv200
431vwx205
532xyz200
533ggg

203

 

And I am looking for a way to filter only those MainID fields which do not have a link to catalog with value 203 or 205. Trying to exclude them. I have tried it with Calculate but now I am troubling with the select criteria.

I am looking forward for your support. Thanks a lot.

  • 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.

5 Replies

  • 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 🙂

    • 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.

  • 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?