Top 10 Spends set expression is giving duplicate dimenssion value

[MEDHA07]

Hi All,

I need to get Top 10 Spends in a Table. I wrote below expression for measure but is giving duplicate dimension row value.

PRBS. Ibm is getting 3 times and my count also increase to 12 .

sum({<SUPPLIER={"=Rank(sum({<TIMEPERIOD={'Q1-2021'}>}[SPEND, USD]),4,0)<=10"},TIMEPERIOD={'Q1-2021'}>}[SPEND, USD])

[Kushal_Chawda]

@MEDHA07  can you share sample data with expected output?