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) from 2 different tables.

 

Below are the DAX function for both measures:

Defect for DPPM = CALCULATE(SUM(LASERLog[# Defect for DPPM calculation]), FILTER(LASERLog, LASERLog[Quality Treatment] = "Product Quality" && LASERLog[Claim Status] = "Accept"))
Order QTY DPPM = CALCULATE(SUM(OrderShipment[Delivery quantity]), FILTER(OrderShipment, OrderShipment[Reporting Plant] = "Puchong Plant"))
 
This is the function for divide:
DPPM % = DIVIDE(
    [Defect for DPPM],OrderShipment[Order QTY DPPM]
)
 
I'm supposed to get for P01 0.384%.
 
Can someone help to check why I'm getting different/wrong result?
 

 

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

3 Replies

  • 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