Show Bottom 5 Custoomer

dokat , Change second have two measures

Rank = RANKX(ALLSELECTED('P&L'[Customer]),('P&L'[W.Trade/NS Shr]),,ASC)

Only 5= sumx(filter(Values('P&L'[Customer]) ,[Rank]<=5) ,[W.Trade/NS Shr])

Hope the bottom five are not all 0

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Hi,

I am not sure how your data model looks like, but I tried to create a sample pbix file like the attached file.

In my attached file, I think your measure is working correctly.

But, I added one more measure and please try to apply it to your model and please check if it works.

I assume your measure shows blank when you put it into the card visualization? Because your measure does not show total value but only shows individual customer's value.

Expected outcome ver2: =
CALCULATE (
    [W.Trade/NS Shr],
    KEEPFILTERS (
        TOPN ( 5, ALLSELECTED ( 'P&L'[Customer] ), [W.Trade/NS Shr], ASC )
    )
)