Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good day!
Can someone help me how to get the first , second until 10th highest value data in a column that will be using in Gauge visual jus like this one:
and also the maximum value is different from each other but I just get it on one column. How can I do that?
Thanks in advance.
-RanHo
Hi @RanHo ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.If not ,pls share a sample data for your case.
Best Regards
Lucien
@RanHo , Try measure like
Rank Discount % = RANKX(all("Item"[Category]),[Discount %],,DESC,Dense)
2nd = calculate( [Rank Discount %], filter( value("Item"[Category]), [Rank Discount %] =2 ) )
or use maxx, sumx or averagex
maxx(filter( value("Item"[Category]), [Rank Discount %] =2 ), [[Rank Discount %])
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |