Forum Discussion

Yinka_212's avatar
Yinka_212
New Member
3 years ago
Solved

Return the total bottom 10 values

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

Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    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.

     

1 Reply

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    3 years ago

    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.