Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Divide 2 measures but getting wrong result

Hi all,   I want to check, why I'm getting the wrong result for the divide function. Below attached the table: I'm dividing 2 measures (Defect for DPPM measure & Order QTY DPPM measure) fro...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    PhilipTreacy  Thanks for your contribution on this thread.

    Hi Anonymous ,

    Please update the formula of measure [DPPM %] as below and check if it can return your expected result...

    DPPM % =
DIVIDE (
    SUMX ( VALUES ( 'Table'[Period] ), [Defect for DPPM] ),
    SUMX ( VALUES ( 'Table'[Period] ), OrderShipment[Order QTY DPPM] )
)

    If the above one can't help you figure out, please provide some fake data in your tables (exclude sensitive data) with Text format and your expected result with special examples just as suggested by PhilipTreacy 。

    How to provide sample data in the Power BI Forum

     

    And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

    How to upload PBI in Community

    Best Regards

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
2 years ago

Hi Anonymous 

 

Please supply your data as a file so people can use it on their own tests.  We can't easily use data posted as an image.

 

regards

 

Phil

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Phil,

     

    The data source is quite confidental, I'm afraid I cannot provide it.
    But, after discussion with one of my colleague, we noticed that the denominator used in the calculation is taken from the total value of the order shipment, instead of order shipment by period.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      PhilipTreacy  Thanks for your contribution on this thread.

      Hi Anonymous ,

      Please update the formula of measure [DPPM %] as below and check if it can return your expected result...

      DPPM % =
DIVIDE (
    SUMX ( VALUES ( 'Table'[Period] ), [Defect for DPPM] ),
    SUMX ( VALUES ( 'Table'[Period] ), OrderShipment[Order QTY DPPM] )
)

      If the above one can't help you figure out, please provide some fake data in your tables (exclude sensitive data) with Text format and your expected result with special examples just as suggested by PhilipTreacy 。

      How to provide sample data in the Power BI Forum

       

      And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

      How to upload PBI in Community

      Best Regards