Forum Discussion
Power BI TOP N
- 6 years ago
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.