Heather
January 26, 2021, 10:00pm
2
There are a few topics on the forum about ranking multiple values, please check these out and see if they can help with your issue. If not, please let us know what is not working.
Hi @Jetuke_ES ,
Play around with this.
Here the number of calls counts for 1, the avg time for 2 divide the result by 3, to rank that.
Ranking with weight factor =
VAR RankWeight =
RANKX(
ALLSELECTED(Sheet2[Agent Name]),
DIVIDE(
RANKX(
ALLSELECTED(Sheet2[Agent Name]),
CALCULATE(SUM(Sheet2[Calls])), , DESC, Dense) +
RANKX(
ALLSELECTED(Sheet2[Agent Name]),
DIVIDE(CALCULATE(SUM(Sheet2[Total Handle Time])), CALCULATE(S…
I believe this is what you want: Edna - multilevel ranking.pbix (26.5 KB)
[image]
Start Date Rank =
VAR CurrentSelection =
SELECTEDVALUE ( Quotes[Start Date] )
VAR DatesGreaterThanCurrentSelection =
FILTER ( ALL ( Quotes[Start Date] ), Quotes[Start Date] <= CurrentSelection )
VAR Result =
COUNTROWS ( DatesGreaterThanCurrentSelection )
RETURN
Result
.
Total Value Rank =
VAR CurrentQuote = [Total Quote Value]
VAR CurrentDate =
SELECTEDVALUE ( Quotes[Start Date] )
VAR Tem…
1 Like
