Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello, Everyone
Is it possible to find TOP 10,20,30, etc,.? I want to show like this image below and can filter by date too.
Thank you in advance for any solution.
Solved! Go to Solution.
Hi , @Anonymous
Here is a demo.
You need to create a calculate column first:
Row Number = COUNTROWS(FILTER('Table','Table'[Amount Dollar]>=EARLIER('Table'[Amount Dollar])))
Enter Table as below:
Then create the measure "pecentage by amount" as below :
Measure =
VAR _topn =
SELECTEDVALUE ( 'Table 2'[TOP N] )
VAR tab =
TOPN ( _topn, 'Table', 'Table'[Amount Dollar] )
RETURN
DIVIDE (
SUMX ( tab, 'Table'[Amount Dollar] ),
CALCULATE ( SUM ( 'Table'[Amount Dollar] ), ALL ( 'Table' ) )
)
The result will show as below:
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi , @Anonymous
Not very clear. Can you explain bit more.
Can you tell me how to calculate "Percentage By Amount" and what is Top N sorted by?
Sample data(excel /pbix file) will make it easier for us to understand your excepted result .
Best Regards,
Community Support Team _ Eason
Dear @v-easonf-msft thank you for ask this question.sorry for my question not clear.
this is my sample data i created. Please kindly check it.
my method that i tried:
1. i create measure for sum amount.
2. i create rank measure
https://jia666-my.sharepoint.com/:x:/g/personal/khihortmrm_xkx_me/Ed_SHMrOvjFJiyBWhXMObRkB2bu9MmT0Ls...
thank you in advance.
Hi , @Anonymous
Here is a demo.
You need to create a calculate column first:
Row Number = COUNTROWS(FILTER('Table','Table'[Amount Dollar]>=EARLIER('Table'[Amount Dollar])))
Enter Table as below:
Then create the measure "pecentage by amount" as below :
Measure =
VAR _topn =
SELECTEDVALUE ( 'Table 2'[TOP N] )
VAR tab =
TOPN ( _topn, 'Table', 'Table'[Amount Dollar] )
RETURN
DIVIDE (
SUMX ( tab, 'Table'[Amount Dollar] ),
CALCULATE ( SUM ( 'Table'[Amount Dollar] ), ALL ( 'Table' ) )
)
The result will show as below:
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Option 1 I can think of is Ranking and binning
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
If there is no filter you can create Rank and rank group on the table
The second option I think of is creating a summarize table then Create a new Rank column and again group rank.
and use this table.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
80 | |
65 | |
52 | |
49 |
User | Count |
---|---|
212 | |
89 | |
79 | |
68 | |
60 |