Forum Discussion
help rank data
Hello Community, I need to categorize a visual by the below: Black / platinum is the 5% of the entity with highest spend Gold is top 20% to top 5% Silver is top 50% to top 20% Bronze is b...
I forgot to unfilter the table, updated in the first post
medal =
var tbl =
CALCUATETABLE(
SUMMARIZE(
tabl2,
table1[Code],
table1[Name],
tabl2[YEAR],
tabl2[Month]
),
ALLSELECTED()
)
var platinum = PERCENTILEX.INC(tbl, [Spend], 0.95)
var gold = PERCENTILEX.INC(tbl, [Spend], 0.8)
var silver = PERCENTILEX.INC(tbl, [Spend], 0.5)
var val = [Spend]
RETURN
SWITCH(
true,
val >= platinum, "Platinum",
val >= gold, "Gold",
val >= silver, "Silver",
"Bronze"
)