Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Measure Total is not matching

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

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      Anonymous
      Not applicable

      Anonymous ,

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

       

       

      Thanks!