Adding a new column with a calculated formula in a Matrix

[jonatan_ap]

Hi everybody,

I have a Matrix with Questions as a Column and Answers as Rows. Per each answer, I have 2 values, the number of answers and the total % per answer. Like this:

I need to add a Column at the end of the matrix (the one on green) with the average score per question, the formula for question 1 is different than the rest of the questions: 

Question 1: ='Yes #' / ('Yes #' + 'No #') * 0.5

Question 2: ='Attempted/Needs Work (1) #' / ('Did Not Attempt (0) #' +'Attempted/Needs Work (1) #' + 'Fundamentally Sound (2) #') * 0.5

Is there a possible way to do this?  

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...