Output Unique Rank for Same value in a table

[jpmuk]

ID	Value	Area	Concatanation	Desired Output
A1	24	AAA	A124	1
A1	24	BBB	A124	2
A2	13	AAA	A213	1
A2	13	BBB	A213	2

Hi, 
I've got a table laid out similar to the above.  I would like to create a column that gives these values a rank based on a concatanation of the ID and Value. 
For example. A124 would appear twice. but i would like the first instance to display as 1, the second as 2 and so on. 

Does anyone know how I could acheive this with a DAX function?

I've managed tis in excel previously, but that was simple using the specific dynamic ranges based on cell address. 

[Anonymous · Accepted solution]

HI @jpmuk,

I think this should more suitable to achieve in the query editor, you can add an index column based on column groups:

Create Row Number for Each Group in Power BI using Power Query - RADACAD

Regards,

Xiaoxin Sheng

[amitchandak]

@jpmuk , refer if Rank Tie breaker can help
https://community.powerbi.com/t5/Community-Blog/Breaking-Ties-in-Rankings-with-RANKX-Using-Multiple-...
https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/