Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all, I am trying to create a column showing the revenue percentile of customers. I want to be able to show in my report generally how large a customer is in comparison to other customers, kind of like a peer group percentile by revenue. Does anyone know how to do this?
I have a Customer slicer on my report and want when I select a single customer, I want it to display the percentile in a Card visual. I forgot to add this extra detail before. Any thoughts?
Customer | Revenue | Percentile (desired column) |
A | 4 | 20 |
B | 6 | 40 |
C | 10 | 60 |
D | 12 | 80 |
E | 15 | 100 |
Solved! Go to Solution.
Hi @Anonymous
According to my understanding ,you want to use Card visual to display rank when the custom has been selected in slicer, right?
You could use the following formula:
Rank/Total =
RANKX (
ALL ( CustomRevenue ),
CALCULATE ( SUM ( CustomRevenue[Revenue] ) ),
,
ASC,
SKIP
)
/ COUNTX ( ALL ( CustomRevenue ), CustomRevenue[Customer] )
My visualizations look like this:
Hi @Anonymous
According to my understanding ,you want to use Card visual to display rank when the custom has been selected in slicer, right?
You could use the following formula:
Rank/Total =
RANKX (
ALL ( CustomRevenue ),
CALCULATE ( SUM ( CustomRevenue[Revenue] ) ),
,
ASC,
SKIP
)
/ COUNTX ( ALL ( CustomRevenue ), CustomRevenue[Customer] )
My visualizations look like this:
Hi jack421,
Rank/Total =
RANKX (
ALLSELECTED ( CustomRevenue ),
CALCULATE ( SUM ( CustomRevenue[Revenue] ) ),
,
ASC,
SKIP
)
/ COUNTX ( ALL ( CustomRevenue ), CustomRevenue[Customer] )
/(4+6+10+12+15) =
DIVIDE ( CustomRevenue[Revenue], SUM ( CustomRevenue[Revenue] ) )
@Anonymous
please try to create two measures
total = sum('table'[Revenue])
Measure =
VAR _rank=RANKX(all('table'[Customer]),[total],,ASC)
return _rank*(1/CALCULATE(DISTINCTCOUNT('table'[Customer]),all('table')))*100
Proud to be a Super User!
Hi Ryan, I appreciate the help here. I just edited my post with an additional detail. I have a slicer on my report where I'd like to select a single customer (i.e. Customer A) and use the Card visual to display that this customer is in the 20th percentile of customers in terms of revenue. Any thoughts?
@Anonymous
I think you can apply a slicer and use card visual to show the result
Proud to be a Super User!
@Anonymous , refer for percentile
https://blog.enterprisedna.co/implementing-80-20-logic-in-your-power-bi-analysis/
https://forum.enterprisedna.co/t/testing-the-pareto-principle-80-20-rule-in-power-bi-w-dax/459
https://finance-bi.com/power-bi-pareto-analysis/
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculate-the-sum-of-the-top-80/td-p/763156
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |