Hi, I'm a beginner to PowerBI and just learning by doing, looking for youtube videos etc. I do not know DAX or any coding at the outset.
I'm trying to learn quickly for a deadline so please suggest simple solutions with minimal or simple coding please!
On my sample spreadsheet I'm dealing with the yellow highlighted fields. There's s '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) I am filtering on 'Pass' just to show the 'Pass' but only getting the values. But what I want to show is the % passed out of the total cohort for each year. So for 'All' the Total % 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
Do I need to do calculations in Excel first or can I/should I do it all in PowerBi and how?! Thanks