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

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.