Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculated column with percentile

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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:

    Are these results what you want? If you have any questions, please upload some data samples and expected output.
    Please do mask sensitive data before uploading.
     
    Best Regards,
    Eyelyn Qin

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi jack421,

Is this column of Percentile the result you want or is it a known condition? Could you explain to me the logic of last column?
According to my understanding, the calculations will look like this:

 

 

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] ) )

 

 

Please tell me more data details and do mask sensitive data before uploading.
Best Regards,
Eyelyn Qin