topic Re: Dax Help in DAX Commands and Tips

Dax Help

Anonymous — Thu, 25 Mar 2021 16:45:21 GMT

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?

Re: Dax Help

Jihwan_Kim — Sun, 28 Mar 2021 05:58:45 GMT

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.

Re: Dax Help

Markus_Re — Mon, 29 Mar 2021 11:30:26 GMT

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!