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...
pawelj795Post Prodigy
Post ProdigyMariusz
Formuła działa prawie prawidłowo.
Potrzebuje tylko zmienić by do zwracanej wartości (Inventory Value EUR) nie był brany filtr na Trans Type, tzn wartość powinna być wyliczana YTD ale dla każdego typu Trans Type.
Mariusz
Community Champion
Community ChampionHej Pawel,
sprobuj tego,
M =
VAR __tbl =
FILTER(
GROUPBY(
CALCULATETABLE(
WH_Invent_Trans,
--KEEPFILTERS( WH_Invent_Trans[TransType] IN { 0, 9 } ),
KEEPFILTERS( WH_Invent_Trans[QTY] <> BLANK() ),
ALLEXCEPT( WH_Invent_Trans, WH_Invent_Trans[ItemID] )
),
WH_Invent_Trans[ItemID],
"@maxDate", MAXX( CURRENTGROUP(), WH_Invent_Trans[DatePhysical] )
),
VAR __days = DATEDIFF( [@maxDate], TODAY() -1, DAY )
RETURN __days > 0 && __days <= 276 --changed as 15 was out of range
)
RETURN
CALCULATE(
SUM( WH_Invent_Trans[Inventory Value EUR] ),
TREATAS( __tbl, WH_Invent_Trans[ItemID], WH_Invent_Trans[DatePhysical] )
--DATESYTD(DimDates[Date]);
)
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.
- pawelj795
Chyba nie do końca dobrze wytłumaczyłem wszystko.
Chodzi o to, żeby do wiekowania, wybór indeksów był na podstawie trans type 0 i 9. -> czyli w _tbl filtr musi pozostać.
Natomiast do wyliczenia wartości wybranych indeksów były brane wszystkie transakcje (bez filtra na trans type). -> jak wyłączyć filtr na trans type w Treatas?- Mariusz
Hej pawelj795
Spobuj, tego
M = VAR __tbl = FILTER( GROUPBY( CALCULATETABLE( WH_Invent_Trans, KEEPFILTERS( WH_Invent_Trans[TransType] IN { 0, 9 } ), KEEPFILTERS( WH_Invent_Trans[QTY] <> BLANK() ), ALLEXCEPT( WH_Invent_Trans, WH_Invent_Trans[ItemID] ) ), WH_Invent_Trans[ItemID], "@maxDate", MAXX( CURRENTGROUP(), WH_Invent_Trans[DatePhysical] ) ), VAR __days = DATEDIFF( [@maxDate], TODAY() -1, DAY ) RETURN __days > 0 && __days <= 276 --changed as 15 was out of range ) RETURN CALCULATE( SUM( WH_Invent_Trans[Inventory Value EUR] ), TREATAS( SUMMARIZE( __tbl, WH_Invent_Trans[ItemID] ), WH_Invent_Trans[ItemID] ) --DATESYTD(DimDates[Date]); )Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.