Divide 2 measures but getting wrong result

[Anonymous]

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?

[PhilipTreacy]

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]

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 · Accepted solution]

@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