Forum Discussion
Need Help
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...
You may refer to the following post.
https://community.powerbi.com/t5/Desktop/Subtotal-Percentages/m-p/313658#M139139
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 |