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.

JarroVGIT's avatar
JarroVGIT
Icon for Resident Rockstar rankResident Rockstar
6 years ago

Hi bobbarker ,

This is a cool question but please never post pictures of your data but a copy or a link to a PBIX/xlsx file so we can actually help you create the required DAX. This is potentially a complicated measure and having some testdata helps in developing it. 

 

Is it possible to share that?
Thanks!

 

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

 

bobbarker's avatar
bobbarker
New Member
6 years ago

Hi JarroVGIT,

thanks for your respone. Under the link, you can find the pbix file with the defined set.

Best