Table from a distinct category

[ggzmorsh]

I would like to create a distinct table from Table1

reference.id	event.id
1	a
2	b
3	c
4	d
5	e
6	a
7	b
8	c
9	d
10	e
11	a
12	b
13	c
14	d
15	e

And the new Table2 would only give me the event.id that has "a".

reference.id	event.id
1	a
6	a
11	a

[Mariusz · Accepted solution]

Hi @ggzmorsh 

The simplest way with use of New Table DAX expression 

Table2 = FILTER( Table1, Table1[event.id] = "a" )

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.