Forum Discussion
Need DAX help with Inventory on Hand
I really need some help with a DAX calculation where I can see how many pieces of Inventory I have at a daily or monthly level. In my data model I have a FactInventory table that has EquipmentID, Cre...
Still no luck with it. It appears to give similar results to the first calc
Anonymous
Try this, if not correct, could you tell the expected result in the sample pbix.
Inventory on Hand =
CALCULATE (
COUNTROWS( 'Table' ),ALL('Table'),DATESMTD('Table'[CreateDate]),FILTER(ALL('Table'),
'Table'[Status] <> "Removed"))
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.