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
Can you please try the following:
PICKS_VALUE £ =
SUMX(
DIM_ITEM,
'DIM_ITEM'[UNIT_PURCHASE_COST] * 'VAL_WHSE_ONHAND_6AM'[ONHAND]
)
If this does not work then I would need to see your data model, especially how the two tables relate to each other and which columns from which table are used in the visual.
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 I got this message when I tried your formula.
This is the realationships of the tables. They are connected using ITEM ID.
Let me know if you need more information.
