Forum Discussion
Anonymous
3 years agoNot applicable
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 AvgC...
Anonymous
3 years agoNot 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
3 years agoNot applicable
Anonymous ,
No this is not working imsted it is going the value of last row of the column.
Thanks!