Show duplicate numbers

[baronraghu]

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

[v-yuezhe-msft · Accepted solution]

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)

Thanks,
Lydia Zhang

[v-yuezhe-msft · Accepted solution]

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)

Thanks,
Lydia Zhang

[baronraghu]

Hi Everyone

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

Thanks

[v-yuezhe-msft · Accepted solution]

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

[Vvelarde]

@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.

[Greg_Deckler]

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