Forum Discussion
Inventory Tracker DAX
alex9999 Hi!
What do you think about calculating a dynamic measure through the ALLSELECTED function and using a filter on the Item in order to calculate the measure related to that ?
BF
Hi BeaBF ,
The solution suggested will not work as I will eventually need to display items in a table so I can view all metrics of each component.
Can you suggest something else?
Kind regards
alex9999 can you paste some data and an example of the expected result for two items? so as to better understand the request and do some tests
BF
BeaBF , my report will have data shown as such:
Date & Time Supervisor In/Out Component Quantity 28/02/2022 11:22 J. Bloggs Out Item A 30 28/02/2022 12:30 J. Bloggs Out Item B 45 28/02/2022 1:35 C. Jones In Item A 22 28/02/2022 2:20 J. Bloggs In Item B 20 This table is being fed through a SharePoint list that is being updated by a foreman who is tracking everything that moves in and out of the unit. Once we do an initial count of the unit and the items in it (which is represented by the first figure of the DAX measure), everything that goes into the unit will be added onto that number, while everything that moves out will be minused from that same figure - leaving us with an accurate figure of each component.
My issue was that I am having to create a measure for every single item individually and I think my computer is going to explode soon.
I'm not sure if there is an easier way to go about creating my report rather than having 600 measures for total quantity and total weight.
Thanks for any help, BeaBF .