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!