Ref rows from the same table

[dpavlov]

I have a knowledge base app where i have Article type as a column. 

How can get i all the rows from the same table where the article type is the same? 

Lets say i have "How to" article type in 10 of 1000 rows. I want when i open an article to see all other rows of the same Article type? 

[dbaum · Accepted solution]

FILTER(Table[Key], [Article type] = [_THISROW].[Article type])

[dpavlov]

Worked! Thanks!

Just w/o the [key]

FILTER(Table, [Article type] = [_THISROW].[Article type])

[dbaum]

Right--of course. I conflated SELECT and FILTER.