My table visualization measure does not return a count of rows (or I have no idea what I am doing)

[Anonymous]

I have a table with the following fields: email, answer, question, question number.

I have a table visualization that shows all answers where question number is 12 (answer is a string)

My goal is to NOT show results in the table if the number of rows to display is less than 5.

I have a measure 

TotalCount = COUNTROWS ( 'umatter-122020' ) and I use it as a filter on the visual to only show if the value is greater or equal than 5.

What is happening is that table displays only results where the number of occurances for that answer is more than 5. 

See image here for more context:

https://imgur.com/a/kQzPVne

This has been keeping me up for too long now.

[mahoneypat · Accepted solution]

If I understand correctly, you can create this measure and then use it to Filter your table visual where it "is" 1.

Show If 5 Answers = IF(COUNTROWS(ALLSELECTED(Answers[Answer]))>=5,1,0)

Regards,

Pat

[Anonymous]

Thank you Pat. The support of the community here is amazing.