How to find weighted average in power bi desktop

[arvindyadav]

Hi Team,

How I can find a weighted average in power bi , for eg

Customer ID	Account Name	Source tag	Profit
8CUST7O36	A	124	2456
8CUO9XHAS	B	124	35415
8CU7Y6683	c	126	24512
8CUY5NJ85	d	234	25201
8CUCWH5Q3	e	124	254
8CU96TBDF	f	126	25421
8CUMQV533	g	234	1454

[v-piga-msft · Accepted solution]

Hi @arvindyadav ,

I have a little confused about your expected output.

It seems that you want to calculate the weighted average, please refer to the similar threads firstly.

https://community.powerbi.com/t5/Desktop/Weighted-Average/td-p/177895

https://community.powerbi.com/t5/Desktop/weighted-average/td-p/347462

If you still need help, please share your desired output based on your data sample so that we could help further on it.

Best  Regards,

Cherry