Looking for filter

[Heidilein]

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
2	26	ijk	201
2	27	lmn	203
3	28	opq	200
3	29	rst	201
4	30	tuv	200
4	31	vwx	205
5	32	xyz	200
5	33	ggg	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 · Accepted solution]

Hi @Heidilein ,

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.

[Heidilein]

Thank you so much, this worked 🙂

[Heidilein]

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?

[ChiragGarg2512]

@Heidilein Does the requirement ask for a filter or a slicer?

[Heidilein]

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