Forum Discussion
mehul26
Helper I
Helper IHelp with getting max record for each employee.
I have a table with Employee, Set column and Rank Colum. For each employee I want to only bring in the max rank. Based on my output below, my pie chart will have 3 counts for SETB and one count for...
aj1973
Community Champion
Community ChampionHi mehul26
use this formula,
MAX Rank =
var _EmplID = SELECTEDVALUE(TABLE[EMPLID])
RETURN
CALCULATE(MAX(TABLE[RANK COLUM], TABLE[EMPLID] = _EmplID)
mehul26Hi Amine,
The highlighted piece is looking for a measure and it does not like table[colum name].
MAX Rank =
var _EmplID = SELECTEDVALUE(TABLE[EMPLID])
RETURN
CALCULATE(MAX(TABLE[RANK COLUM], TABLE[EMPLID] = _EmplID)