Ranking a Measure by Category (Group)

[curtismob]

Hello, I am looking for guidance on getting a rank by category to work for a measure.  Below are my measures and further down is a screen snippet of the desired results.

_mOption Cat Capture Rate CSV =

CALCULATE(DIVIDE(DISTINCTCOUNT('Option SelectionsCSV'[_cLot Option Category]),

'Option SelectionsCSV'[_mCount Lots Closed CSV], 0))

_mCount Lots Closed CSV =

CALCULATE(DISTINCTCOUNT(LotCSV[Lot_ID]),

ALLSELECTED('Option SelectionsCSV'[_cCategory Description]))

_mOption Cat Capture Rate Rank CSV =

VAR

   CaptureRate = 'Option SelectionsCSV'[_mOption Cat Capture Rate CSV]

VAR

   CaptureRateRank = RANKX(ALLSELECTED('Option SelectionsCSV'[_cCategory Description]), 'Option SelectionsCSV'[_mOption Cat Capture Rate CSV], , DESC, Dense)

RETURN

   IF(ISBLANK(CaptureRate), BLANK(), CaptureRateRank)

I have a .pbix for this, but I'm not sure how to upload or where to place it for other to review.

Thank you in advance,

@curtismob 

[parry2k]

@curtismob this blog post talks about ranking in detail, go thru 3 posts on this topic and you will get the solution. 

[curtismob]

Thanks for responding @parry2k.  I have already reviewed the posts you mention in your response and was still not able to get it to work as desired.

[parry2k]

---

@curtismob wrote:

Thanks for responding @parry2k.  I have already reviewed the posts you mention in your response and was still not able to get it to work as desired.

---

@curtismob  can you share pbix file , remove any sensitive info before sharing.

[curtismob]

I apologize, what is the easiest way to share the pbix?

[parry2k]

@curtismob thru one drive or google drive.

[curtismob]

I have it on Onedrive now, how can I share it with you?  Do I need your email address?

[parry2k]

@curtismob you can email directly, my email address is in the signature. 

[parry2k · Accepted solution]

@curtismob Just emailed you the solution, once confirmed it is working, I will post the solution here so that others can benefit from it. Will wait for your response. Cheers!!

[parry2k]

@curtismob solution is attached. Thanks for your patience.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!