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
3 years ago

You 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's avatar
timurcakin
Icon for Helper I rankHelper I
3 years ago

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's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    You may download my PBI file from here.

    Hope this helps.