Forum Discussion

Justas4478's avatar
Justas4478
Post Prodigy
3 years ago
Solved

Table totals showing wrong values

Hi I have a measure multiplies one column with other to do the multiplication. The result values are correct but when I look at the totals at the bottom of the table they are showing much bigger numb...
Need Help
  • Mikelytics's avatar
    Mikelytics
    3 years ago

    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.

    -----------------------------------------------------

    LinkedIn

Justas4478's avatar
Justas4478
Post Prodigy
3 years ago

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.

Mikelytics's avatar
Mikelytics
Resident Rockstar
3 years ago

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.

-----------------------------------------------------

LinkedIn