Forum Discussion

timurcakin's avatar
timurcakin
Icon for Helper I rankHelper I
3 years ago
Solved

multiply column and a measure - wrong total

Hi There,   i am trying to multiply the total quantity of the items with the number of orders (frequency) but in second screenshot total is 190 instead of 86 (64+22)        can you ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

This pattern should work

Measure = SUMX(VALUES(DATA[Item No.]),[Replishment cost])

keinshah's avatar
keinshah
Icon for Helper I rankHelper I
2 years ago

thanks a lot. that worked. 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    2 years ago

    You are welcome.

    • keinshah's avatar
      keinshah
      Icon for Helper I rankHelper I
      2 years ago

      I managed to get the calculation. however, the sum is not showing correct. any ideaas?