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

In the same table, I want to calculate replishment cost only if Purchase = YES. What would be the best way to do it?

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

    Share the download link of the file and show the expected result clearly.

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

      Replenishement cost = reorder quantity * unit cost. But only calculate if Purchase = YES. Blank if purchase = NO and show the sum of the total replenishment cost at the bottom.