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

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.