Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Power BI TOP N

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.
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi , Anonymous 

    Here is a demo.

    pbix attached

     

    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.