I'm pretty new to Power BI and DAX functions and I'm having a bit of trouble trying to get one to calculate correctly. I have exam data that grades a learners performance with either a fail, pass, merit or disitinction. I've created 5 columns that works out what the grades would be if the pass mark for each section was reduced by 1 point each time.
When I've tried to count how many distinctions we would have if the pass mark was reduced by 1 point, it's counting other values as well and I'm not sure why.
Here is my DAX expression:=
Would you please illustrate "works out what the grades would be if the pass mark for each section was reduced by 1 point each time."? Please share sample data in source data table, including table structure and detailed records. Also, make it clear that what your desired result is. How to Get Your Question Answered Quickly