Forum Discussion

Diptarup's avatar
Diptarup
Icon for Helper II rankHelper II
2 years ago
Solved

Getting Sum except TOP 10 rank

I have table, wherein I need to calculate the value of all products which are ranked in Top 10 . Table below :-  So the value I am looking for is 38.46. I have used a meaure to calculate the rank,...
Need Help
Show and Tell
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi Diptarup 
    You can use :

    SumTOPN =
    CALCULATE ( [sum_], TOPN ( 10, 'Table', 'Table'[Value] ))

    pbix is attached

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
2 years ago

Hi Diptarup 
You can use :

SumTOPN =
CALCULATE ( [sum_], TOPN ( 10, 'Table', 'Table'[Value] ))

pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly