Help with percentage for text data

[ejwhelton2222]

Sorry if my question is simple. I'm brand new and can't seem to find the exact right answer for this. I have found some close and I almost get this to work, but can't seem to get it exactly.

My data is a column with Yes, No and In Progress. I need to know the percentage of each response against the total.

[AlB · Accepted solution]

Hi @ejwhelton2222 

1. Place Table1[Column], the column with the answers, in the rows of a visual matrix

2. Create the following measure and place it in the matrix visual (format as % if necessary): 

Answer_Perc =
DIVIDE (
COUNT ( Table1[Column] ),
CALCULATE ( COUNT ( Table1[Column] ), ALL ( Table1 ) )
)

[ejwhelton2222]

Thanks so much. That worked and help me a lot.