Reply
Member
Posts: 47
Registered: ‎01-11-2017
Accepted Solution

Show duplicate numbers

Hi All,

 

I want to see the top 10 spending amount by customers I have the following data

 

Date     Customer Name   Product name    Spending

1/1/2016   David                  Au                     173

1/11/2016  Victor                   In                      171

1/21/2016   Steve                 Au                     164

1/31/2016    David                Au                      158

2/1/2016       Mark                pa                      148

2/15/2016    Jose                  en                      102

2/25/2016   Tim                    nz                       98

.

.

.

.

And so on I have 300 entries

 

The result i want is the top 10 spending amount and name of the customer

 

I used max function to get the maximum spending amount. When i am using the funnel chart as the visual as per customer name and max amount spent measure I am only getting unoque values. But I am unable to get the duplicate values

 

The result should be

David 173

Victor 171

Steve  164

David  158

Mark 154

Jose 102

 

 

 


Accepted Solutions
Highlighted
Moderator
Posts: 9,944
Registered: ‎03-10-2016

Re: Show duplicate numbers

Hi @baronraghu,

Agree with others.

You can create a measure named Rank using the following formula, then create a table visual using Customer Name field and Rank measure, and set Rank measure to be less than or equal to 10 in Visual Level filters.

Rank = RANKX(ALL(Table1),CALCULATE(MAX(Table1[Spending])),,DESC)



1.PNG

 

 


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Moderator
Posts: 9,944
Registered: ‎03-10-2016

Re: Show duplicate numbers

Hi @baronraghu,

As the issue is solved, you can accept helpful replies as answer, this way, other community members would easily find the answer when they get same issues.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post


All Replies
Super User
Posts: 10,605
Registered: ‎07-11-2015

Re: Show duplicate numbers

Sounds like you want to use RANKX to rank the spending amounts and then you could filter that to only the top 10.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Super User
Posts: 1,701
Registered: ‎05-10-2016

Re: Show duplicate numbers

@baronraghu

 

Hi, as my knowledge a Funnel Chart group by category/ column.

 

If you want duplicate name this type of chart doesn't work for you.




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Highlighted
Moderator
Posts: 9,944
Registered: ‎03-10-2016

Re: Show duplicate numbers

Hi @baronraghu,

Agree with others.

You can create a measure named Rank using the following formula, then create a table visual using Customer Name field and Rank measure, and set Rank measure to be less than or equal to 10 in Visual Level filters.

Rank = RANKX(ALL(Table1),CALCULATE(MAX(Table1[Spending])),,DESC)



1.PNG

 

 


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Member
Posts: 47
Registered: ‎01-11-2017

Re: Show duplicate numbers

Hi Everyone

 

Yes i agree with all that Rankx is a perfect solution which gives me the rank.

 

Thanks

Moderator
Posts: 9,944
Registered: ‎03-10-2016

Re: Show duplicate numbers

Hi @baronraghu,

As the issue is solved, you can accept helpful replies as answer, this way, other community members would easily find the answer when they get same issues.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.