Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I have a table with Warehouse transactions. Each transaction is one record, having for example the location number and the changed quantity (also linked to an items table). The "tricky" this is that since it records transactions, i do not have the actual quantity but the "change" (either addition or removal).
The report will have on data slicer. What i am trying to achieve is to ignore the lowest part of the slicer, therefore to be able to obtain status on the maximum selected (by the slicer) date.
I created a measure "Warehouse Total Remaining Quantity" which works ok. Now i am trying to calculate the Distinct Items remaining on the warehouse (not stock quantity). Therefore i need to have the DIstinct Items having quantities on the Max selected date (therefore "Warehouse Total Remaining Quantity">0)
Below you can see the measures along with a table. Basically the table should be able to show "Warehouse Distinct Items" = 1, where the Quantity>0
Thanks
George
Solved! Go to Solution.
Hi,
This measure works
Measure2 = COUNTROWS(FILTER(CALCULATETABLE(VALUES(Items[PartNo]),DATESBETWEEN('Date'[Date],MAX('Date'[Date]),MAX('Date'[Date]))),[Warehouse Total Remaining Quantity]>0))
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |