Forum Discussion
timurcakin
Helper I
Helper Imultiply 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 ...
timurcakinHelper I
Helper IHi 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!
Ashish_Mathur
Super User
Super UserYou are welcome. If my previous reply helped, please mark that reply as Answer. Try this measure
Measure 3 = DIVIDE([Measure 2],CALCULATE([Measure 2],ALL(Sheet3[No_])))Hope this helps.
- timurcakin
Absolute Legend!!
thank you very much Ashish
- Ashish_Mathur
You are welcome.
- timurcakin
I will need one more thing, do i need to open a new post for it?
As this is a measure (and not a column) i am struggling to get the cumulative % of measure 2, is this something you can help with?
- timurcakin
Hi Ashish,
I will need one more thing, do i need to open a new post for it?
As this is a measure (and not a column) i am struggling to get the cumulative % of measure 2, is this something you can help with?
- Ashish_Mathur