Ranking Values from one table based off filtered results from different table

[Jordan_Lopez]

Hi everyone, 

I am new to Power BI/Dax and am hoping someone can help me with a  measure I am trying to create. I am trying to rank values from one column that are grouped based off an ID from a different table. 

See sample data below. I am attempting to compare and rank all Values in Table2 where the ProductIDs from Table2 share a ResultID from Table1 (Table2[ProductId] = Table1[Id]). The Rank column on the far right is the result I am looking for; note the adjacent ResultId column is merely for reference to help illustrate the behavior I am looking for. 

Any help here would be greatly appreciated. Thank you!

Table 1		Table 2
Id	ResultId		Id	ProductId	Value		ResultId	Rank
20814365	2435355		106260433	20814365	104		2435355	1
20814366	2435355		106260437	20814366	100.875		2435355	2
20814367	2435355		106260441	20814367	100.75		2435355	3
20814368	2435355		106260445	20814368	100.75		2435355	3
20814369	2435355		106260449	20814369	100.625		2435355	4
20814370	2435355		106260453	20814370	100.5		2435355	5
20814371	2435355		106260456	20814371	100.375		2435355	6
20814372	2435355		106260459	20814372	100.375		2435355	6
20814373	2435355		106260463	20814373	100.25		2435355	7
20814374	2435355		106260466	20814374	100.25		2435355	7
20814375	2435355		106260470	20814375	100		2435355	8
20814376	2435355		106260474	20814376	100		2435355	8
20814377	2435355		106260477	20814377	100		2435355	8
20814378	2435355		106260480	20814378	100		2435355	8
20814379	2435355		106260483	20814379	99.875		2435355	9
20814380	2435355		106260487	20814380	99.25		2435355	10
20814381	2435356		106260490	20814381	100.177		2435356	3
20814382	2435356		106260494	20814382	100.336		2435356	2
20814383	2435356		106260498	20814383	100.582		2435356	1

[parry2k]

@Jordan_Lopez there is detailed blog post talk about ranking with mutiple scenarious, here is the link, hope it helps.