Forum Discussion

ajohn_ben's avatar
ajohn_ben
Frequent Visitor
3 years ago
Solved

Incorrect Total

Hi, 

Can anyone please help me with my DAX measure? I'm getting an incorrect total with my DAX below:

 

 

final dollar = 

VAR cond1 = FILTER(
        'Staff Data',
        'Staff Data'[REC_LEAVE_CURR_BALANCE_DAYS]>'Staff Data'[FTE _Excessive Leave_]*40
    )
VAR comprate_oncost =
CALCULATE(
    MAXX('Staff Data','Staff Data'[COMPRATE])+(MAXX('Staff Data','Staff Data'[COMPRATE])*[On cost %]),
    cond1
)
VAR hourly_rate = 
CALCULATE(
    comprate_oncost/(MAXX('Staff Data','Staff Data'[STD_HRS _Custom SQL Query_]*52.17856)),
    cond1
)

VAR schedHrsPerWeekDiv5 = 
CALCULATE(
    MAXX('Staff Data','Staff Data'[SCHEDULE_STD_HRS_PER_WEEK]/5),
    cond1
)
VAR RecBalance_RecThresholdFTE = 
CALCULATE(
    (MAXX('Staff Data','Staff Data'[REC_LEAVE_CURR_BALANCE_DAYS])-(MAXX('Staff Data','Staff Data'[FTE _Excessive Leave_]*40)))*schedHrsPerWeekDiv5*hourly_rate,
    cond1
)  

RETURN 
    SUMX(cond1,RecBalance_RecThresholdFTE)

 

 

 

The total should be 2,312,373, but what I get is 


NB. The row values are correct .




2 Replies