How to rank Top N and other Properly

[YILE]

Hi,

I have a stacked bar chart for Top 30 looks like below. Remaining Suppliers are above the last supplier. How can I fix this?

Here is the rankx I use:

Rank =

IF(

    [Total Amount] <> BLANK(),

    RANKX(

        TOPN(

            SELECTEDVALUE('TopN Selection'[Top Suppliers]),

            ALLSELECTED('Pseudo Supplier Table'),

            [Total Spend]

        ),

        [Total Spend],,

        ASC,

    Dense

    )

)

Can anyone helps me? 

[amitchandak]

@YILE , for Top you should use DESC not ASC

try like

Sumx(keepfilters(
TOPN(
SELECTEDVALUE('TopN Selection'[Top Suppliers]),
ALLSELECTED('Pseudo Supplier Table'),
[Total Spend], desc
)),
[Total Spend]
)

or

calculate([Total Spend] ,keepfilters(
TOPN(
SELECTEDVALUE('TopN Selection'[Top Suppliers]),
ALLSELECTED('Pseudo Supplier Table'),
[Total Spend], desc
))

)

Learn Power BI: Dynamic TOPN using TOPN/Window and Numeric parameter: https://youtu.be/vm2mdEioQPQ