% of total

[joshcomputer1]

Straight forward question here.....I have read the other incidents related to % of totals and I think mine is similar, but can't figure it out.  I have a column named 'Dataset'[count] that is either a 1 or 0.  I want to be able to get the count of QuestionNum column (so I Know how many times that question was answered) and also the percentage of 1s of the total.  I am assuming that after I have this, I can slicer or filter by the month/year.

[sumit4732]

Hi @joshcomputer1

If i understand your question correctly, you want count and %of total for each Question.

Its quiet simple actually, just pull Question as Values in table, pull count as Values which should take sum by default

and again pull count with sum as summarization type post that right clikc on values and got to show value as and select %of Grand Total

I think this should do it.

Thanks

[joshcomputer1]

Okay, I added questionNum and Count. It shows the total and then the number of "yes" or 1s. The third column is count again (sum) and I changed it to % of grand total. The issue with that % is that it's a % of total by month.  Not the % of total for that month. Still need help to get the percentage. 

[v-shex-msft]

Hi @joshcomputer1,

Did you try to use 100% stacked column chart? It will show the value as the percent.

Regards,

Xiaoxin Sheng

[joshcomputer1 · Accepted solution]

I ended up adding two columns. One for No responses [QuestionNumNo] and one for yes responses[QuestionNumYes].  Then used the following to divide the yes's by the total.  This seems to work.

QuestionNumPerc = sum('DataSet'[QuestionNumYes]) / (sum('DataSet'[QuestionNumYes])+sum('DataSet'[QuestionNumNo]))

[cartman21]

Had a similar query - appreciate you sharing the solution, thanks!

[Interkoubess]

Hi,

Could you please give us a sample of data in order to compute it.

Thank you.