RANKX by Product by Value (multiple categories)

[Anonymous]

Hi Experts

How would you rank products based on the values in the data set. See images below i have ranked each product based on the values for that products so each product group has its own ranking. (if that makes any sense). 

[v-juanli-msft]

Hi @Anonymous 

Create columns

rank = RANKX(FILTER('Table','Table'[product]=EARLIER('Table'[product])),[value],,ASC,Dense)

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

THanks you maggie and god bless...

[amitchandak · Accepted solution]

Refer

https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures

Ranking by Sub Category = 
	RANKX (
		FILTER(
			ALL(
				'Table'[Category],
				'Table'[Sub Category]
				),
			'Table'[Category] = MAX('Table'[Category])
			),
			CALCULATE(SUM('Table'[My Value]))
			)

[Anonymous]

Hi Amit

i need to add this as calculated column....into a table..

[Anonymous]

silly question whats Category and sub Category from my example...