Rank by Sum If

[KH_Mike]

Hi All,

Can anyone give me the DAX how to rank like this?

The data set is as follow

Type 1	Type 2	Price
TV	A	10
TV	A	10
STB	A	10
STB	A	10
STB	A	10
TV	B	20
TV	B	20
STB	B	20
STB	B	20
STB	B	20

I want to show it like this

Type 1	Type 2	Price	Rank
TV	A	20	2
TV	B	40	1

[amitchandak · Accepted solution]

@KH_Mike ,

rankx(allselected(Table[Type1], Table[Type2]), calculate(sum(Table[Price])), ,desc,dense)

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures