Forum Discussion

samirineni's avatar
samirineni
Frequent Visitor
5 years ago

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 ...
Need Help
samdthompson's avatar
samdthompson
Memorable Member
5 years ago

Maybe something like this:

 

Rank = RANKX(ALLSELECTED(Table2[PeerVendor]),
CALCULATE(sum(Table1[Qty]),
ALLEXCEPT(Table2, Table2[PeerVendor])
)
)
 
When you display that in say a matrix with month along the columns you will find it shows the rank by month.
 
 

 

 

samirineni's avatar
samirineni
Frequent Visitor
5 years ago

samdthompson 

I did create dynamic rank measure but looking for peer rank using another table in relation in dynamic way. the suggested solution works for regular rank only.

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

    Hi  samirineni,

     

    Can you advise me what the expected output you need?I may have a misunderstanding...

     

    Best Regards,
    Kelly

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