Calculating Percentage

[ccoslow]

Hello,

I'm not sure if I'm phrasing any of this correctly, and this is probably a really simple fix that I'm not seeing. Ultimately, I'm trying to show the percentage of students retained by academic year for each program. The columns below obviously show the academic years, then drill down to the "Retained" column in my query which results in two columns on the matrix: "N/A" and "Retained" (no numeric data in that column in the raw data file), and the count for the "Retained" column. 

Is there a way I can add either:

a) add a third calculated sub-column after "Retained" that shows the % of students retained based off of the previous two columns, or

b) have one column per academic year with the percentage retained? All of the percentage calculations I've seen for the "value" field only show percentage calculated by row, column, or grand total. 

Here's what my "fields" section looks like if that helps.

Thank you (and I apologize if this doesn't make much sense - my brain is fried)!

[v-frfei-msft]

Hi @ccoslow ,

Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

[ccoslow]

@v-frfei-msft @Nathaniel_C 

Thank you for your help! I've figured out a solution by creating multiple measures using DAX. 

[Nathaniel_C · Accepted solution]

@ccoslow ,

You will have to write a measure to figure the percentage. So if I understand the issue you would like another column say, for 2010-2011 that would show 75% for Accupuncture Master. Is that correct?

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel