Re: Normalizing column in matrix that is based on ...

Anonymous · ‎07-22-2020

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 · ‎07-22-2020

@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.⚡

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.