How to show percentage calculation of aggregate AND segments on line chart (text fields)

[Eternally333]

Hi, I'm a beginner to PowerBI and do not know DAX or any coding at the outset.

On my sample spreadsheet I'm dealing with the YEAR, RESULT, GENDER fields.

There's a 'picture' of the result I want to get to. How can I:

1) Show a line for 'All' (the Total) AND for each Gender. I can only seem to get just Male and Female alone

2) Just show the 'Pass' Result - but what I want to show is not the counts for 'Pass' but the % passed out of the total cohort for each year. Passed % out of all each year and for each Gender, the % Passed from each Gender total each year. And show everything Year by Year in a time series as below line chart.

[So 1950 there were 8 students: Pass rate all 50%, 4 Males with Pass Rate 100% 4 Females with Pass Rate 0%]

Do I need to do calculations in Excel first or can I/should I do it all in PowerBi and how?!

[Eternally333]

This is as far as I managed to get so far with Filter for 'Pass' on 'Result'. I need the 3rd line showing the Total of Male + Female. And I need % Pass Rates for all three instead of Counts.

[Eternally333]

Thanks for reply, appreciate it. I can't use my work account to send the file and don't have another account right now. Will the data table below be ok please to help? Appreciate it, thanks

Year	Result	Discipline	Gender
1950	Pass	Arts	M
1950	Pass	Arts	M
1950	Pass	Arts	M
1950	Pass	Arts	M
1950	Fail	Arts	F
1950	Retake	Sciences	F
1950	Retake	Sciences	F
1950	Retake	Arts	F
1951	Fail	Sciences	M
1951	Retake	Sciences	M
1951	Pass	Arts	F
1951	Pass	Arts	F
1952	Pass	Arts	F
1952	Pass	Arts	M
1952	Pass	Arts	F
1952	Fail	Sciences	M
1953	Pass	Arts	F
1953	Retake	Sciences	F
1953	Fail	Arts	M
1954	Pass	Arts	M
1954	Pass	Sciences	M
1954	Pass	Sciences	F
1954	Fail	Sciences	F
1954	Retake	Arts	M

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[Eternally333 · Accepted solution]

Yes Ashish, marvellous! I followed all your Measures calculation steps and it works exactly. It's exactly right, many kind thanks 👍

[Ashish_Mathur]

You are welcome.  If my reply helped, please mark it as Answer.

[Ashish_Mathur]

Hi,

Share the download link of your PBI file.