Forum Discussion

joshcomputer1's avatar
joshcomputer1
Icon for Helper V rankHelper V
9 years ago
Solved

% of total

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 ...
Need Help
  • joshcomputer1's avatar
    joshcomputer1
    9 years ago

    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]))

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi joshcomputer1,

 

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

 

Regards,

Xiaoxin Sheng

joshcomputer1's avatar
joshcomputer1
Icon for Helper V rankHelper V
9 years ago

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's avatar
    cartman21
    Icon for Helper I rankHelper I
    9 years ago

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