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.

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

I want the total replenishment cost to show the sum of indivudual costs and not as a product of total unit cost and total re -order quantity. how do I solve it?

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?

  • 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.