Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Powerbi PPM calculation

Hi Powerbi Community, I am struggeling with a PPM calculation I am trying to preform.   All files do have relationship between them. I do have the total quantity supplied to several customers...
Need Help
Show and Tell
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    Change formula of PPM to the following , then create visuals combining different fields with this measure and check if the measure returns your expected result.

    PPM = CALCULATE(SUM('Supporting Data'[Quantity Reported]))/CALCULATE(SUM('Main Data'[Net Inv QTY]),ALLSELECTED('Main Data'))*1000000



    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Lydia,

Sorry for late reply.

Dummy Data hereby the link to the dummy data.

I didn't get the part you wanted me to put the expected results in table format ? Do you have an example.

Thank you,

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous，

I am not able to access the above file. I want to know your expected result based on the dummy data, it is easy for us to understand if you put the expected result in table or cells.

Regards,
Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Dropbox Link

    Hi Lydia,

    OneDrive I cannot share the data as it has been disabled.

    I do understand you want it in table format. But I do not know the formula to get that typ of result for excel, I have to dive in to it.

    So you are saying you do not know where I want to go with the explanation.

    I want a Parts per million calculation.

    Per family "Part name"
    Per customer total.
    Per customer Location.

    Current formula in Powerbi is use = "Doesn't show the correct data", shows for customer location all the same PPM.

    PPM = CALCULATE(SUM('Complaint Tracking'[Quantity Reported]),ALLSELECTED('Complaint Tracking'[Customer Location]))
    /
    CALCULATE(SUM('0112017_CQE_Data'[Net Inv QTY]),ALLSELECTED('0112017_CQE_Data'))*1000000

    Second question would be, do I need several PPM calculations to do the 3 above cases or can I do it with 1 formula.