Forum Discussion
Help with percentage for text data
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.
Hi Anonymous
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 ) )
)
2 Replies
- AlB
Community Champion
Hi Anonymous
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 ) )
)