Forum Discussion

PPD's avatar
PPD
Icon for Helper I rankHelper I
5 years ago
Solved

Average based on Groups

Hi, I am new to Power BI, and would like to achieve the following results for "Average by Customer" and Average by Customer Region" in the existing table.   This report is generated using Direct qu...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi, PPD 

    Try to  create measure as below:

    M% = [Measure 2] /[Measure 1]
    Average by customer = AVERAGEX(SUMMARIZE('Table','Table'[Product],'Table'[Customer Region],"M%",[M%]),[M%])
    Average by Customer Region = CALCULATE( [Average by customer],ALL('Table'))

     

    Please check attached pbix for more details.

     

    Best Regards,
    Community Support Team _ Eason

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, PPD 

Try to  create measure as below:

M% = [Measure 2] /[Measure 1]
Average by customer = AVERAGEX(SUMMARIZE('Table','Table'[Product],'Table'[Customer Region],"M%",[M%]),[M%])
Average by Customer Region = CALCULATE( [Average by customer],ALL('Table'))

 

Please check attached pbix for more details.

 

Best Regards,
Community Support Team _ Eason

  • PPD's avatar
    PPD
    Icon for Helper I rankHelper I
    5 years ago

    Hi v-easonf-msft Eason, 

    Thank you for your response, and sharing the PBIX file. Please see my response below.