Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
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
Hi 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
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.
Sounds like you want to use RANKX to rank the spending amounts and then you could filter that to only the top 10.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |