Forum Discussion

ThisIsHalloween's avatar
ThisIsHalloween
Icon for Helper I rankHelper I
2 years ago
Solved

Ranking Formula by Week Help Needed (pbix file link attached)

I am trying to have a conditional formatting to rank users by week in the "Welcome Center" location only and to ignore $0 or blanks. Red is the lowest amount of the week and green is the highest amou...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    Conform = 
var a = CALCULATETABLE(VALUES(Employees[User ]),REMOVEFILTERS(Employees[User ]))
var b = ADDCOLUMNS(a,"t",CALCULATE(sum('Data by Week'[Total])))
return if(max('Sorting Location'[Sorting Location])="Welcome Center",divide(sum('Data by Week'[Total])-minx(b,[t]),maxx(b,[t])-minx(b,[t])))
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

link requires login - please check.