Measure for counting depending on the date slicer and status

[Anonymous]

Hello! Say I have a list of students passing some exams (аn analogue of my product management task). Each row includes the name of student, subject, date of submission, check date and grade. For simplification purposes let's consider only one week. Let's consider the following table (in it's latest/actual version):

And I need to create a measure to count how many students there are depending on grade and date. Exams with check date greater than slicer date are considered to be unverified (when the check date is out of slicer upper bound).

I've tried a lot of approaches playing around with different filterings (KEEPFILTERS, ALLSELECTED, etc) and nothing good happend. Also I created a measure from the calendar to help out:

date_upper = CALCULATE(MAX(dates[date]), ALLSELECTED(dates))

Any help is appreciated! Thanks is advance.

[daxer-almighty]

@Anonymous 

Please mark my answer as the solution so that others can find it easier and to boost my status on the forum. Thank you.

[daxer-almighty · Accepted solution]

@Anonymous 

Here's a full solution. Study it carefully because it's not very easy. Requires a rather good command of DAX (and logic) to understand.

[Anonymous]

Huge thanks for quick response! Btw, I've spotted an issue, that some values fall out of total sum in the row context.

[daxer-almighty]

"And I need to create a measure to count how many students there are depending on grade and date."

You're wrong in your answer. You're calculating the number of students in the current context. My formula is absolutely correct.

[Anonymous]

I really appreciate your help. Thank you a lot. I've fixed this a little bit to satisfy the original requirement (count exams, not students), but I still have the issue with a total sum along rows. I can't come up with the way around.

[Anonymous]

Oh, my bad. I meant the number of exams. That's what the illustrations about - to count how many exams particular student took with partition by subject and grades according to the date slicer. My sample with only unit values is pretty misleading

[aj1973]

@daxer-almighty 

Was your reply for me?

I think you were mistaken, I am not the one who opened this thread 

[daxer-almighty]

You thought correctly.

[aj1973]

Hi @Anonymous 

Can you provide a Sample of your file