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...
mehul26Helper I
Helper IHi 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)
aj1973
Community Champion
Community ChampionHi
Sorry didn't understand your reply.
Can you share your file? it would be easier for us to help.
- mehul26
I can't seem to attach my pbix file but here is an image. Its a simple file with one table.
- aj1973
Please use Onedrive, google drive or any cloud service to upload your file and share the link
- mehul26
See if you are able to download this pbix file. https://mantech.box.com/s/r2apq38wtz8yc5n5c5cup6li2i38lp19