Forum Discussion
Solved
Total running - filters
Hi
I have this messaure that works fine in my totals.
_Cuml Stock Value NEW =
CALCULATE (
SUMX ('Item ledger Entry' , RELATED(Products[Internal Cost]) * ('Item ledger Entry'[Quantity]) ),
FILTER ( ALL( 'Item ledger Entry'), 'Item ledger Entry'[Posting Date] <= MAX ('Item ledger Entry'[Posting Date]) )
)
But see here, if i try to get the stock value by [Item Tracking Code] i don't get the corect result.
In this example, should [_Cuml Stock Value NEW] be se same as the value in the coulm [Stock Value]
In this example, should [_Cuml Stock Value NEW] be se same as the value in the coulm [Stock Value]
Here is my tables and relations
Can you see what is wrong here?
Hi Lund ,
In the dax code where you are using
FILTER(ALL('Item Ledger Entry'[Item Tracking Code] add the column name too, hope this should work.
Regards,
Nikhil Chenna
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
1 Reply
- NikhilChenna
Skilled Sharer
Hi Lund ,
In the dax code where you are using
FILTER(ALL('Item Ledger Entry'[Item Tracking Code] add the column name too, hope this should work.
Regards,
Nikhil Chenna
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!