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,

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