Problem with max values

[#1]

Hi there,

I'm struggeling for some time now and can't find the solution.

I have a record set as stated below:

PersonName	EducationLevel	EducationLevelDescription
Arno	9	HBO
Arno	8	MBO
Michael	7	VMBO
Michael	9	HBO

I have two objectives in my model. In the dashboard tab I do want to show the Personnames with highest education level descriptions. In the detail tab I want the complete history of all the employees.

I really think this should be easy, so it's a quite frustrating

How do I solve this? Thx!

[#2 · Accepted solution]

Create a straight Table

Dimension

PersonName

Expression

FirstSortedValue(EducationLevelDescription,-EducationLevel)

[#3]

Thanks!

So close... I feel really silly now