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 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
- AnonymousNot 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 ) ) )- AnonymousNot applicable
Anonymous ,
No this is not working imsted it is going the value of last row of the column.
Thanks!