percentage of text data

[Anonymous]

Hi everyone, I'm building my first dashboard and I have a problem with percentage of text data.

I have a column with Yes/No/I don't know/blank answers. I need to calculate the persentage of each option (except null) and build a graph where I'm going to put a time dimension to see a trend. Could you please help me? Which function should I use? Thank you!

[TomasAndersson · Accepted solution]

Hi!

I'm assuming now that you have a column with dates and another column with answers.

First create a measure counting the amount of answers. If you have null answers, "-countblank" is not needed. If the answers are blank, however, you need that additional function.

TotalAnswers = COUNTA('Table'[Answer])-COUNTBLANK('Table'[Answer])

Then for each option create measures. You can do that in two steps as below, or combine each as a single measure.

nYes = CALCULATE(COUNT('Table'[Answer]),'Table'[Answer]="Yes")
Yes% = 'Table'[nYes]/'Table'[TotalAnswers]

And then just put it in any visual you like. Hope it helps!

[Anonymous · Accepted solution]

Thank you very much, Tomas! It helped!

[TomasAndersson · Accepted solution]

Hi!

I'm assuming now that you have a column with dates and another column with answers.

First create a measure counting the amount of answers. If you have null answers, "-countblank" is not needed. If the answers are blank, however, you need that additional function.

TotalAnswers = COUNTA('Table'[Answer])-COUNTBLANK('Table'[Answer])

Then for each option create measures. You can do that in two steps as below, or combine each as a single measure.

nYes = CALCULATE(COUNT('Table'[Answer]),'Table'[Answer]="Yes")
Yes% = 'Table'[nYes]/'Table'[TotalAnswers]

And then just put it in any visual you like. Hope it helps!