SUM or SUMX of RANX over rows in one column

[Han_Solo]

Hello,

Recently I got help here with one issue and now I've found another one. I have this table 

the index_new is calculated: 

Index_New = RANKX(ALLSELECTED('data'[Product Name]),[Sales_sum],,DESC,Dense)

the TEST measure is calculated:

TEST = 
VAR _table = ADDCOLUMNS(SUMMARIZE(data, data[Product Name]), "abc", RANKX(ALLSELECTED('data'[Product Name]),[Sales_sum],,DESC,Dense))
RETURN
SUMX(_table, [abc])

And I want it to give me row sum of the index value which is 276. But is it possible to do this in one column?
Like I would like to have 276 in total but proper index values (1:23 etc) ? 

link to template:
https://we.tl/t-MVv1Z3m2lj

Thank you for your help 

[parry2k]

@Han_Solo glad to help!

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k · Accepted solution]

@Han_Solo change your test measure to this

TEST = 
//VAR _table = ADDCOLUMNS(SUMMARIZE(data, data[Product Name]), "abc", [Index_New])
//RETURN

IF ( HASONEFILTER(data[Product Name]), [Index_New],SUMX(values(data[Product Name]), [Index_New] ))

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Han_Solo]

@parry2k 
Of course, I overcomplicated things. Thank you for pointing that out and helping me with second thing 🙂
I've thought that it's possible to do this without HASONEFILTER/HASONEVALUE functions but apparently it is not.