Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Normalizing column in matrix that is based on a measure

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

Need Help

1 Reply

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

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