finding if a value appears at least once in a column filtered by another column

[Anonymous]

I need help finding if a value appears at least once in a column filtered by another column.

Following the simplified Table, I need to check if the ID has been registered at least once for the class.

ID	Class	Registered to Class 1111?
AAAA	1111	Yes
BBBB	2222	No
BBBB	3333	No
BBBB	4444	No
CCCC	1111	Yes
CCCC	4444	Yes
DDDD	3333	No
EEEE	1111	Yes
EEEE	2222	Yes

My school of thought was to filter each ID and check wheter or not one of the class where the specified class, a but ended up getting nowhere. I can do it if I create a new table, but I need it to bein a column of the same table.

[fhill]

How's this custom column?

VAR an Array of 'Good' IDs where Class = 1111   (Or whatever you are seraching for...)

Then if current row's ID is 'Contained' in the Array, YES, else NO

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Please check the below for creating a new column.

Registered to Class 1111? =

VAR currentid = 'Table'[ID]

VAR alltablefilteredbycurrentid =

SUMMARIZE ( FILTER ( 'Table', 'Table'[ID] = currentid ), 'Table'[Class] )

RETURN

IF ( { 1111 } IN alltablefilteredbycurrentid, "Yes", "No" )

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM