Rank & Rankx for calculated column in calculated table

[Amrselim1989]

Dear Guys,

kindly note i have calculated table which is i summerize sales by product name in it, so fine so far 

after this i used new column to calculate a column 

Rank Net Sales = RANKX ( 'Products Header', [Header Total Sales],, DESC, DENSE )

so fine so far 

but the problem starts now, i want to rank the product category depending on total sales for this category and I have to put it in the same calculated table just like below 

any help?!

[devanshi]

Total Sales = SUM([Sales])

Category Ranks = RANKX(ALL('Table'),[Total Sales],Desc)

[some_bih]

Hi @Amrselim1989 your measure to rank sales by category could be

Rank by category=RANKX(ALL(Table1[Category]); CALCULATE(SUM(Table1[Sales]));;DESC)

Adjust Table1 to your table name

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

[Amrselim1989]

unfortunately, it doesn't work, it only gives me two values instead of four.

there a screen shot if i make a sperate table for brand and i ranked it

but i can't rank it in the details table based on the summation of brand sales

any help??!

[some_bih]

Hi @Amrselim1989 my solution is measure. Go to your pivot table and put this measure into pivot table and check results.

[Amrselim1989 · Accepted solution]

i found my solution 

Rank by category = RANKX(ALL('Products Header'[BRAND_NAME]), CALCULATE(sum('Products Header'[Total Net Sale]),ALLEXCEPT('Products Header','Products Header'[BRAND_NAME])),,DESC,Dense)

thank you

[Amrselim1989]

No, i don't want it as a measure it must be a calculated column, it must be a calculated column for other purposes

thank you for your patience.