Normalizing column in matrix that is based on a measure

[Anonymous]

Hello,

I created the matrix below in power bi. In a nutshell, I'm trying to normalize the "Employee Score" column using the "max" value of that column, but I am finding this to be a challenge for some reason. Employee Score column is based off of a measure.

The calculation  would be "Employee Score"/Max(Employee Score) = Employee Score /0.257.

I have tried MAX, MAXA, and MAXX, but only MAXX(Employee Score) returned a value and that value was not 0.257. Any help in understanding why I cannot directly compute the max value of matrix column would be greatly appreciated.

Best,

Andrew

[parry2k]

@Anonymous try this

New Measure = 
DIVIDE ( [Employee Score], MAXX ( VALUES ( Table[Auditor] ), [Employee Score] ) )

assuming auditor  is an employee or change Table[Auditor] to Table[Employee]

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡