Measure Total is not matching

[Anonymous]

Hi Team,

Below is my measure and my column totals are not matching, please help me. 

Inventory_Result_Calculation =

VAR AvgFISCPER = AVERAGE('src_horizon v_horizon_aggregate'[FISCPER])

VAR AvgCurrentFISCPER = AVERAGE('src_horizon v_horizon_aggregate'[CURRENT_FISCPER])

VAR MaxYear = MAX('src_horizon v_horizon_aggregate'[YEAR])

VAR MaxMonthNumber = MAX('src_horizon v_horizon_aggregate'[Month_Number])

VAR MaxWeek = MAX('src_horizon v_horizon_aggregate'[WEEK])

VAR MaxProductGroup = MAX('src_horizon v_horizon_aggregate'[PRODUCT_GROUP])

RETURN

    IF(

        AvgFISCPER < AvgCurrentFISCPER,

        SUM('src_horizon v_horizon_aggregate'[ACT_INV]),

        CALCULATE(

            SUM('src_horizon v_horizon_aggregate'[INVENTORY_NATIONAL]),

            FILTER(

                ALLSELECTED('src_horizon v_horizon_aggregate'),

                'src_horizon v_horizon_aggregate'[YEAR] <= MaxYear &&

                'src_horizon v_horizon_aggregate'[Month_Number] <= MaxMonthNumber &&

                'src_horizon v_horizon_aggregate'[Week] <= MaxWeek &&

                'src_horizon v_horizon_aggregate'[PRODUCT_GROUP] <= MaxProductGroup

            ),

            ALL('src_horizon v_horizon_aggregate'[YEAR], 'src_horizon v_horizon_aggregate'[MONTH])

        )

    )

Thanks !

Rakesh

[Anonymous]

hi @Anonymous ,

try updated measure 

Inventory_Result_Calculation =
VAR AvgFISCPER = AVERAGE('src_horizon v_horizon_aggregate'[FISCPER])
VAR AvgCurrentFISCPER = AVERAGE('src_horizon v_horizon_aggregate'[CURRENT_FISCPER])
VAR MaxYear = MAX('src_horizon v_horizon_aggregate'[YEAR])
VAR MaxMonthNumber = MAX('src_horizon v_horizon_aggregate'[Month_Number])
VAR MaxWeek = MAX('src_horizon v_horizon_aggregate'[WEEK])
VAR MaxProductGroup = MAX('src_horizon v_horizon_aggregate'[PRODUCT_GROUP])

RETURN
    IF(
        AvgFISCPER < AvgCurrentFISCPER,
        SUM('src_horizon v_horizon_aggregate'[ACT_INV]),
        CALCULATE(
            SUM('src_horizon v_horizon_aggregate'[INVENTORY_NATIONAL]),
            FILTER(
                ALLSELECTED('src_horizon v_horizon_aggregate'),
                'src_horizon v_horizon_aggregate'[YEAR] <= MaxYear &&
                'src_horizon v_horizon_aggregate'[Month_Number] <= MaxMonthNumber &&
                'src_horizon v_horizon_aggregate'[Week] <= MaxWeek &&
                'src_horizon v_horizon_aggregate'[PRODUCT_GROUP] <= MaxProductGroup
            )
        )
    )

[Anonymous]

@Anonymous ,

No this is not working imsted it is going the value of last row of the column.

Thanks!