Forum Discussion
Using overall maximum for a gauge visual
Hi, I have a dataset of student performance data with test results, student id and various demographic details. I have created a 'profile' page for each student containing demographic data as wel...
hi Anonymous
You may need to use this measure
Maximum Student Score = CALCULATE(MAX('Student Data'[FINAL_MARKS]), ALL('Student Data'))
or
Maximum Student Score = CALCULATE(MAX('Student Data'[FINAL_MARKS]), ALLEXCEPT('Student Data', 'Student Data'[ID]))
Regards,
Lin
Whether it's correct or not depends on what filters are in place at the time this measure is being applied and what your model looks like.
If you filter on the name of the student, then this ALL filter does not do anything as long as the names are unique.
If you want to remove all filters from the 'Student Data' table, you should use ALL( 'Student Data' ).
Best
D
If you filter on the name of the student, then this ALL filter does not do anything as long as the names are unique.
If you want to remove all filters from the 'Student Data' table, you should use ALL( 'Student Data' ).
Best
D