Create a table based on a condition

[nemo]

I have the following table

Score	Comment	Person
1		p1
2		p1
3		p1
4		p1
	abc	p1
2		p2
3		p2
4		p2
5		p2
		p2

How can I create another table that contains only rows for person p1 who provided a comment? The desired output should look like this

Score	Comment	Person
1		p1
2		p1
3		p1
4		p1
	abc	p1

Thank you.

[PVO3 · Accepted solution]

Hi, 

Try this:

Table = 

VAR _tbl = SUMMARIZE(FILTER('Table', NOT ISBLANK('Table'[Comment])), 'Table'[Person])

RETURN

CALCULATETABLE(

    'Table',

    'Table'[Person] IN _tbl

)

[nemo]

Hi @PVO3 , thank you for a clear and easy to follow solution. Much appreciated.

I tried to use the following formula hoping it would return the desired result

Table 2 = 
VAR comments = CALCULATETABLE( VALUES('Table'[Person]), 'Table'[Comment] <> "") 
VAR tbl = FILTER('Table', 'Table'[Person] = comments)
RETURN tbl

However, it resulted in this error 

<ccon>A table of multiple values was supplied where a single value was expected.</ccon>

Could you please tell me what that error meant? What's wrong with my formula?