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 ar...
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.

     

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.