I am working on ranking clients based using the Rank.EQ Dax Equation. I am running into an issue where the rank is always 1. Here is the set up:

Rank.EQ measure:

Pull Through Ranking = RANK.EQ(Fact_ClientPullThrough_RptOps[Current Pull Through],Dim_Client[Pull Through],DESC)

Dim_Client[Pull Through] measure:

Pull Through = [Current Pull Through]

Current Pull Through measure:

Current Pull Through = CALCULATE([UW Requested Pull Through], PARALLELPERIOD(Dim_Date[Current_DT],0,MONTH)) 

Dim_Client is joined to Fact_ClientPullThrough_RptOps. The values in the client id column in Dim_Client are all unique.Also, the pull through measure on the fact pull through table is for the current month so not every client in the dim client table will have a value, some are null.

Thank you for helping and let me know if I need to clarify more.

Ideally I would want to adjust the ranking where the client status is active and only rank based on active clients. But I want to fix the base DAX Equations first.