Forum Discussion

MarkSmash's avatar
MarkSmash
Frequent Visitor
2 years ago
Solved

Measure for Unique Records from Previous Term

Hello,   I'm looking to get a measure, "Unique Students Last Year," which would be the number of unique records from the previous term (in this case a term is a school year). The scores are based o...
  • speedramps's avatar
    speedramps
    2 years ago

    Click here to download the solution
    Download PBIX 


    How iit works ...

    Students this year = 
DISTINCTCOUNT(TestScores[Student])

     

    Students previous year = 
VAR thisref= SELECTEDVALUE(SchoolYear[Order])
VAR previousref= thisref - 1
RETURN
CALCULATE(
DISTINCTCOUNT(TestScores[Student]),
ALL(SchoolYear),
SchoolYear[Order] = previousref)

     

    Please click both  the ACCCEPT SOLUTION button and the thumbs up buttons.

    If you need more help then please raise a new ticket and quote speedramps 
    I will receive an automated notifcation and will try help

     

speedramps's avatar
speedramps
Icon for Super User rankSuper User
2 years ago

Thank you for the kudos.
If you need more help then raise a new ticket and quote speedramps anywhere in the text,  I will then receive an automatic notification and will be delighted to help you again.
Please always try provide example input data as table text (not a screen print) so we can import the data to build a solution for you. You will gain respect and a much quicker and better responses with the more effort put in to describing problems