Forum Discussion
Table totals showing wrong values
HI Justas4478
sorry, I identified another missing piece (i think". Please try:
PICKS_VALUE £ = SUMX( DIM_ITEM, 'DIM_ITEM'[UNIT_PURCHASE_COST] * CALCULATE(SUM('VAL_WHSE_ONHAND_6AM'[ONHAND])) )Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
-----------------------------------------------------
Hi Justas4478
right ... can you please try:
PICKS_VALUE £ =
SUMX(
DIM_ITEM,
'DIM_ITEM'[UNIT_PURCHASE_COST] * SUM('VAL_WHSE_ONHAND_6AM'[ONHAND])
)
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
-----------------------------------------------------
Mikelytics No error this time but totals still wrong. I guess the totals are looking at more items than just the ones on the table maybe.
HI Justas4478
sorry, I identified another missing piece (i think". Please try:
PICKS_VALUE £ = SUMX( DIM_ITEM, 'DIM_ITEM'[UNIT_PURCHASE_COST] * CALCULATE(SUM('VAL_WHSE_ONHAND_6AM'[ONHAND])) )Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
-----------------------------------------------------
Mikelytics It worked. Thank you. Could you explain what was wrong and why solution you provided worked so I could understand and learn?
