cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
baronraghu Member
Member

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

 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Moderator v-yuezhe-msft
Moderator

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.
Moderator v-yuezhe-msft
Moderator

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.
5 REPLIES 5
Super User
Super User

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.


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

Vvelarde Super Contributor
Super Contributor

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 v-yuezhe-msft
Moderator

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.
baronraghu Member
Member

Re: Show duplicate numbers

Hi Everyone

 

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

 

Thanks

Moderator v-yuezhe-msft
Moderator

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.

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 129 members 1,746 guests
Please welcome our newest community members: