Filtering

patolattari · ‎02-22-2018

Hi!

Quick question, I have a query with the following data:

Student Name

Evaluation Date

Score

I need to visualize the last score obtained by every student and given that there are many evaluations for each one, I suppose i have to use the Top N filter but i'm not sure, could you please help me with that?

thank you!

v-xjiin-msft · ‎02-22-2018

Hi @patolattari,

To achieve your requirement, you can try following measure:

Last Score =
CALCULATE (
    MAX ( 'Table'[Score] ),
    FILTER ( 'Table', 'Table'[Date] = MAX ( 'Table'[Date] ) ),
    ALLEXCEPT ( 'Table', 'Table'[Student] )
)

Thanks,
Xi Jin.

ricardocamargos · ‎02-22-2018

Hi @patolattari,

If your visual just has those 3 columns you can use this code:

_Last Score =
VAR maxDate = CALCULATE(LASTDATE(Table1[Date]); ALLEXCEPT(Table1; Table1[StudentID]))
RETURN
CALCULATE(DISTINCT(Table1[Score]); FILTER(ALL(Table1); Table1[Date] = maxDate))

I hope it helps you.

Ricardo