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

     

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!