Forum Discussion
Measure Total Incorrect
Hello Experts I'm encountering a classic issue with the Measure total. I have a following Measure that works correctly at each row level in the Table visual. ====================================...
Hi slokam ,
Thanks rajendraongole1 for the quick reply. I have some other thoughts to add:
You can try to create a new measure.
PO Allocated Quantity By Trans Number Test =
SUMX(VALUES('ItemTransactions'[Source Trans Number]),[PO Allocated Quantity Test])
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HI Anonymous
Thank you for your proposed solution, apparently it's working for some scenarios but not all. After analysing looks like following calculation is not correct. This calculation is to get onHandQty at Item level, where as the above output is at Transaction level. Can you please let me know how can i get ITEM level( One Item can have multiple transNumbers) Totals in this calculation?
======================================
VAR vTotalOnHandQty =
CALCULATE(
SUM(ItemTransactions[Trans Quantity]),
FILTER(
ALL('ItemTransactions'),
'ItemTransactions'[Item ID] = MAX('ItemTransactions'[Item ID])
&& 'ItemTransactions'[Sub Inventory] = MAX(ItemTransactions[Sub Inventory])
&& 'ItemTransactions'[Trans Date] <= MAX('Dates'[FullDateAlternateKey])
)
)
=======================================
Also can you please clarify what's the difference between SUMMARIZE Vs VALUES solution your proposed?
Thanks a lot for your help, much appreciated.
slokam