cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jordan_Lopez Occasional Visitor
Occasional Visitor

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

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   
IdResultId IdProductIdValue ResultIdRank
208143652435355 10626043320814365104 24353551
208143662435355 10626043720814366100.875 24353552
208143672435355 10626044120814367100.75 24353553
208143682435355 10626044520814368100.75 24353553
208143692435355 10626044920814369100.625 24353554
208143702435355 10626045320814370100.5 24353555
208143712435355 10626045620814371100.375 24353556
208143722435355 10626045920814372100.375 24353556
208143732435355 10626046320814373100.25 24353557
208143742435355 10626046620814374100.25 24353557
208143752435355 10626047020814375100 24353558
208143762435355 10626047420814376100 24353558
208143772435355 10626047720814377100 24353558
208143782435355 10626048020814378100 24353558
208143792435355 1062604832081437999.875 24353559
208143802435355 1062604872081438099.25 243535510
208143812435356 10626049020814381100.177 24353563
208143822435356 10626049420814382100.336 24353562
208143832435356 10626049820814383100.582 24353561

 

 

 

1 REPLY 1
Super User
Super User

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

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





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.