Forum Discussion
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
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 ZhangHi 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
5 Replies
Sounds like you want to use RANKX to rank the spending amounts and then you could filter that to only the top 10.
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.
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 ZhangHi Everyone
Yes i agree with all that Rankx is a perfect solution which gives me the rank.
Thanks
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
