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

Hi,

Share the download link of the PBI file.

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

Hi Ashish,

i modified it a bit as it was connected to the database. 

TEST- Copy.pbix

but ultimately what i want to do is to divide "measure3" per line to grand total of "measure" (which is wrong or not what i want in the file) 

i want to see 31,214,080 instead of 5,221,978,332

 

hope that make sense

thanks in advance

timur

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    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!

       

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

    • surajlodh_maha's avatar
      surajlodh_maha
      New Member
      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?

    • surajlodh_maha's avatar
      surajlodh_maha
      New Member
      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?

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        2 years ago

        Hi,

        I do not have that file.  Share some data, explain the question and show the expected result.