Forum Discussion
Ranking Measure Help over Peer Group
I have below scenario in my datamodel and looking for solution to create measure for ranking with vendor versus peer vendor. Table A: VendorID Date Qty A 2021-01-31 100 B ...
Hi samirineni ,
How to show the peer vendor rank,is it something like below:
If so,create 2 columns as below:
_rank 1 = RANKX(FILTER(ALL('Table A'),MONTH('Table A'[Date])=MONTH(EARLIER('Table A'[Date]))),'Table A'[Qty],,ASC)_rank 2 =
LOOKUPVALUE('Table B'[Custom],'Table B'[Peer_VendorID],'Table A'[VendorID])
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
I am not sure why you added index value as static and it doesn't help. i have derived my regular dynamic rank but looking help to create peer rank using another table with relationship.