Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dax Help

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?

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    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.

  • Markus_Re's avatar
    Markus_Re
    Resolver I
    5 years ago

    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!