Need Help

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.