how to calculate sum, average price and the number of orders

[sniper007]

Hello guys im working with formulas in order to calculate some measures , so here we go i have two columns "somme_quantité"(orders) and "famille de groupe"(family article) , i want from family article to create new columns (3 new columns)r in order to calculate  sum, average price and the number of orders  ...

NB : each family article contains different items ,

here's some screenshoots :

orders :

article family :

so here is a group of article family like SERVICE , MARBLE LOCALE and others each one contains items

thank you

[v-yiruan-msft]

Hi @sniper007 ，

Could you please share some sample data in the table(exclude sensitive data) and your expected result with specific example and calculation logic in order to provide you a suitable solution? It is better if you can share your sample pbix file. Thank you. By the way, does these fields(price,"somme_quantité"(orders) and "famille de groupe"(family article) ) come from one same table? 

In addition, you can refer the content in the following links to get it:

Create and use your own measures

Power BI Aggregate Functions

Best Regards

[amitchandak]

@sniper007 ,

I think pivot in the power query can create that easily for you if that can be used for this case

https://radacad.com/pivot-and-unpivot-with-power-bi