Need Help

[Kiran_Gundu]

Hi, 

Please find the below requirement.

I have data like below , i know the total cost of each project and individual employees revenue. 

Now I need to calculate profit and profit percentage based on total cost and total revenue.

total profit = total revenue - total cost. 

Indivial profits = total profit / total revenue * revenue

profit percentage = individual profit / total profit * total profit percentage

I have calculate in one filed, same as for remainig one. can you please help me to generate report in power bi.

Project	Empno	Empname	Cost	Revenue	Profit	Profit Percentage
Project 1	1	A		30000	46000/81000*30000=17037	17037/46000*56.79=21.03
Project 1	2	B		15000
Project 1	3	C		36000
Project 1	0	Dummy	35000	81000	46000	56.79
Project 2	5	E		36000
Project 2	6	F		28000
Project 2	7	G		39000
Project 2	0	DUmmy	47000
Project 3	9	I		25000
Project 3	10	J		30000
Project 3	11	K		40000
Project 3	0	Dummy	50200

[v-chuncz-msft]

@Kiran_Gundu,

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/Subtotal-Percentages/m-p/313658#M139139

[Kiran_Gundu]

HI,

Below is data, I want to calculate profit and profit percentage for below data in pwer bi.

If I filter project column then it should be calcualte based on filtering and should be dispaly profit and profit %

Example - if i filter project1 -> profit should be calculated revenue - cost

                                            -> profit % should be calculate profit / revenue.

             - if I filter project 2 & 3 -> Profit should be calculate for these two (total revenue) - total cost

                                                   -> Profit % should be calculate total profit / total revenue.

Project	Empno	Empname	Cost	Revenue
Project 1	1	A		30000
Project 1	2	B		15000
Project 1	3	C		36000
Project 1	0	Dummy	35000
Project 2	5	E		36000
Project 2	6	F		28000
Project 2	7	G		39000
Project 2	0	DUmmy	47000
Project 3	9	I		25000
Project 3	10	J		30000
Project 3	11	K		40000
Project 3	0	Dummy	50200