Forum Discussion

bobbarker's avatar
bobbarker
New Member
6 years ago
Solved

DAX count in date range (slicer)

Hi togheter, I got a challange where I can need some support / hints of the community 🙂 The data source is a list where a row is generated every time a student take an exam. Looks like this: ...
Need Help
Tips and Tricks
  • mwegener's avatar
    mwegener
    6 years ago

    Hi bobbarker ,

     

    check this out

    Number of students per level =
VAR MaxLevelPerStudent =
    SUMMARIZE (
        ALLEXCEPT ( List, List[DATE] ),
        List[STUDENT],
        "@LEVEL", MAX ( List[LEVEL] )
    )
RETURN
    COUNTROWS (
        FILTER ( MaxLevelPerStudent, [@LEVEL] = SELECTEDVALUE ( List[LEVEL] ) )
    )

    Regards,

    Marcus

    Dortmund - Germany
    If I answered your question, please mark my post as solution, this will also help others.
    Please give Kudos for support.

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

Hi bobbarker ,

 

check this out

Number of students per level =
VAR MaxLevelPerStudent =
    SUMMARIZE (
        ALLEXCEPT ( List, List[DATE] ),
        List[STUDENT],
        "@LEVEL", MAX ( List[LEVEL] )
    )
RETURN
    COUNTROWS (
        FILTER ( MaxLevelPerStudent, [@LEVEL] = SELECTEDVALUE ( List[LEVEL] ) )
    )

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.