Return the total bottom 10 values

[Yinka_212]

Hi,

I will like to return the total bottom 10 values ,only the total. i already used Ranx function but it returned all bottom 10 with no totals, anyone here to help please?

e.g Bottom numbers are 1,2,3,4,5, I want to return 15 only

[v-jingzhang · Accepted solution]

Hi @Yinka_212 

You can use TOPN and then SUMX them. Create a measure like below

Measure = SUMX(TOPN(10,'Table','Table'[Column1],ASC),'Table'[Column1])

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.