Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Create a straight Table
Dimension
PersonName
Expression
FirstSortedValue(EducationLevelDescription,-EducationLevel)
Create a straight Table
Dimension
PersonName
Expression
FirstSortedValue(EducationLevelDescription,-EducationLevel)
Thanks!
So close... I feel really silly now