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.

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

Hi Ashish,

 

Total is correct thank you, Is it possible to find weighted average of these?

Measure 2 per item / total measure 2

that would be Legendary!

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

I've having this same issue.  Is there any way the formula can be shared since the PBIX file is no longer available?