RANKX By Grouping for a given date period

[deskow80]

I have three tables:

DateDimension

Employee

Settlement

The Employee table has a column labeled TrainingClass

I am trying to create a rank that will update dynamically based on the date range selected by BilledContributions from the Settlement table.

I have a measure called TotalBilledContributions:

TotalBilledContributions =

VAR _StartDate = MIN(DateDimension[Date])

VAR _EndDate = MAX(DateDimension[Date])

RETURN

SUMX(

    FILTER(Settlement,Settlement[BatchDate] >= _StartDate && Settlement[BatchDate] <= _EndDate),

    Settlement[BilledContributions]

)

And I have a calculated column called RankbyTrainingClass:

RankbyTrainingClass =

VAR _StartDate = MIN(DateDimension[Date])

VAR _EndDate = MAX(DateDimension[Date])

RETURN

RANKX(

    FILTER(

        ALL(Employee),

        Employee[TrainingClass] = EARLIER(Employee[TrainingClass])

    ),

    CALCULATE([TotalBilledContributions],Settlement[BatchDate] >= _StartDate && Settlement[BatchDate] <= _EndDate),

    ,

    DESC,

    Dense

)

Link to .pbix file in Google Drive: PBIX file 

I was expecting the rank to be based on the TotalBilledContributions measure decending, but I'm not getting that as a result. Any help is greatly appreciated. I'm getting unexpected results as follows: 

EmployeeName	TotalBilledContributions	RankbyTrainingClass
Ryan K	1,581.69	1
Brandon S	109.52	2
Lionel R	397.60	3
Will C	30.60	4
Nathan H	30.06	5

[deskow80]

I changed the ranking to a measure instead of a calculated column and modified the DAX to:

Rank =

VAR _StartDate = MIN(DateDimension[Date])

VAR _EndDate = MAX(DateDimension[Date])

RETURN

CALCULATE(

    RANKX(

        FILTER(

            ALL(Employee),

            Employee[TrainingClass] = SELECTEDVALUE(Employee[TrainingClass])

        ),

        CALCULATE([TotalBilledContributions],Settlement[BatchDate] >= _StartDate && Settlement[BatchDate] <= _EndDate),

        ,

        DESC,

        Dense

    ),

    ALLSELECTED(Employee[TrainingClass])

)

This appears to be working as desired. If you see any issues, let me know.