Total running - filters

[Lund]

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]

Here is my tables and relations

Can you see what is wrong here?

[NikhilChenna · Accepted solution]

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!