Тотал считается неверно при наличии if statement

Как посчитать корректер тотал, если группировка по году , месяцу и имени работника.

    SUMMARIZE (
      -- loan_agreement,
        --loan_agreement[year],
       -- loan_agreement[date],
       -- loan_agreement[Responsible person],
    dim_pos_responsible_person,
   -- bonus,
   -- bonus[year],
    --bonus[month_name],
    --bonus[responsible_PRM],
    dim_pos_responsible_person[pos_responsible_person],
        "x",
        /*IF(
                [Active POS]>=[Active POS targeted], [Active POS bonus money], 0
                    )
           
    ),
    ''[x]
)*/
           SWITCH (
                TRUE (),
                [Selected Measure] = 1,
                    IF (
                        Metrics[Active POS] >= SUM ( bonus[active_pos_target] ),
                        SUM ( bonus[active_pos_bonus_euro] ),
                        0
                    ),
                [Selected Measure] = 2,
                    IF (
                        Metrics[Active POS] >= SUM ( bonus[active_pos_target] ),
                        SUM ( bonus[active_pos_bonus] ),
                        0
                    )
            )
    ),
    [x]
)*/
 или так

VAR x = IF( [Active POS]>=[Active POS targeted], [Active POS bonus money], 0 )

RETURN 
IF( HASONEVALUE(dim_pos_responsible_person[pos_responsible_person] ),
    x,
        SUMX( VALUES(dim_pos_responsible_person[pos_responsible_person]), IF( [Active POS]>=[Active POS targeted], [Active POS bonus money], 0 ) )) ```