Calculate students with grade 4 and above in certain subjects

DAX DAX Calculations
1

Hi, thanks for your help. I’m based in the UK and over here our pupils are assessed and given grades 1 to 9, where 1 is the lowest grade and 9 is the highest grade. Each pupil is assessed over various subjects and given a 1 to 9 grade. A pass is considered to be a grade 4 or higher, so I have created measure to count up how many grade 4 or higher each pupil has. So far, so good.

My problem is that pupils are also assessed in the grades they get in Maths, English and English Literature (i.e. across three subjects). My customers (i.e. schools) need to be able to identify how many pupils got a grade 4 or above in Maths, plus a grade 4 or higher in English or English Literature.

So to count for this measure they first need to have a grade 4 or higher in maths, and eithe English or Engligh Literature (or both) also need to be grade 4 or higher.

I can’t get my head around the dax for this measure. Any help gratefully received.

Assessment.pbix (2.4 MB)

2

@DavidP,

Welcome to the forum – great to have you here!

A brief while back I did a video on an approach for greatly simplifying the DAX for these types of complex conditionals.

Give this a watch – I think it will give you what you need to solve this problem yourself, but if not, just give another shout we will be happy to work through the specific DAX.solution with you.

I hope this is helpful.

– Brian

3

Hi @DavidP, did the response provided by @BrianJ help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!

4

That was a great solution - works a treat and simplifies the DAX to make it easy to read.

1 Like
5

@DavidP,

Excellent - really glad to hear that worked well for you.

  • Brian