Forum Discussion
pawelj795
Post Prodigy
Post ProdigyQuickly DAX measure fix - Filter
Hi, I want to slightly modify my measure. Currently, it looks like that: Aging = VAR ItemID = SELECTEDVALUE(WH_Invent_Trans[ItemID]) RETURN DATEDIFF(MAXX( FILTER(ALL(WH_Invent_Trans); WH...
Mariusz
Community Champion
Community ChampionHi pawelj795
Try something like this.
Aging =
VAR ItemID = SELECTEDVALUE( WH_Invent_Trans[ItemID] )
RETURN
DATEDIFF(
MAXX(
FILTER(
ALL( WH_Invent_Trans );
WH_Invent_Trans[ItemID] = ItemID
&& WH_Invent_Trans[TransType] IN { 0, 9 }
&& WH_Invent_Trans[QTY] <> BLANK
);
WH_Invent_Trans[Date Physical]
);
TODAY()-1;
DAY
)Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Mariusz
If this post helps, then please consider Accepting it as the solution.
pawelj795That works, thanks 😉
Now, I want to develop this measure.Groups = VAR ItemID = SELECTEDVALUE(WH_Invent_Trans[ItemID]) VAR DateDifference = DATEDIFF( MAXX( FILTER(WH_Invent_Trans; WH_Invent_Trans[ItemID]=ItemID && WH_Invent_Trans[TransType] IN {0;9} && WH_Invent_Trans[QTY] <> BLANK() ); WH_Invent_Trans[Date Physical]); TODAY()-1; DAY) RETURN CALCULATE( SUM( WH_Invent_Trans[Inventory Value EUR]); DATESYTD(DimDates[Date]); DateDifference > 0 && DateDifference<= 15)
But it doesn't work.
It shows:
the true/false expression does not specify a column. Each true/false expressions used as table filter expression must refer to exactly one column