Forum Discussion
Measures Calculating Incorrectly at Line Level
Hello, Hoping someone can help me. I'm trying to do something very simple and basic in Power BI, yet each attempt using different methods is coming up incorrecct as well. I have inventory it...
AlexisOlson I was finally successful and was able to create the proper sum per item using this measure:
Current Qty = SUMX(SUMMARIZE(vw_TubingShortage_InventoryUsage,[Item Name],[CurrentQty]),[CurrentQty])It's doesn't make sense to me why that would necessarily be the "correct" sum but you could do something like this:
SUMX ( SUMMARIZE ( Table1, Table1[Item Name], Table1[Current Qty] ), Table1[Current Qty] )
AlexisOlson thank you.
So how would I solve the issue of summing the amounts to reflect the correct value regardless of the date? The sum should be 130.
Thank you.
AlexisOlson I was finally successful and was able to create the proper sum per item using this measure:
Current Qty = SUMX(SUMMARIZE(vw_TubingShortage_InventoryUsage,[Item Name],[CurrentQty]),[CurrentQty])