Dax Help

[Anonymous]

Good Afternoon 

I have a combined table in power BI relating to student results in a recent data drop. I have a column of subject names for example English Language, Mathematics etc. i then have a column of grade value which has a value of what was achieved in each subject. I can to a measure that counts the number of results for english above a 4 however I need to do a measure that counts the number of students achieving above a 4 in both english and maths. Can anyone help?

[Markus_Re]

Hi, @Anonymous 

I hope this will be able to help you:

I created a table that looks like this:

so in this case, as far as i understood,  the count for your case would be 2 (John & Max). 

For counting i used this Measure:

MathsAndEnglishAbove4 = 

var _filteredTable = FILTER(StudentGrade, (StudentGrade[Subject] = "Mathematics" && StudentGrade[Grade] >= 4) || (StudentGrade[Subject] = "English" && StudentGrade[Grade] >= 4))
var _groupedTable = GROUPBY(_filteredTable, Student[StudentID], "count", COUNTX(CURRENTGROUP(), StudentGrade[StudentID]))
var _result = COUNTX(FILTER(_groupedTable, [count] >= 2), [count])

RETURN

_result

Best regards,

Markus

Did I answer your question? Mark my post as a solution!

[Jihwan_Kim]

Hi, @Anonymous 

If the question is still open, and if it is OK with you, please share your sample PBIX file. Then I can come up with a more accurate measure to solve the problem.

Thank you.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.