Dear Experts

I am learning Power Pivot at the moment so please bear with me if you find this query a basic one.

I have customers divided into Departments. I have a Power Pivot Table showing customers in the first column and in the third column, I have income from each customer. In the last column, I calculated the % of each customer income as the total income of the company. The formula I used is:

=sum('Monthly Party-wise Income'[Income])/CALCULATE(Sum('Monthly Party-wise Income'[Income]),ALL('Monthly Party-wise Income'))

So, I can see how much each of the customers is contributing to company income in term of %. 

I have now created the slicers based on Departments. So when I select a slicer for any one of the departments, I want to calculate % of each customer income to the total income of the department I selected in the slicer. In other words, I want to see how much each customer is contributing to that particular department income in term of %. And I want it dynamic i.e. as I select another department in the slicer, it should calculate % for that particular department only that is selected in the slicer.  

I have so many tables in file and the data is confidential so cannot share. But I add a screenshot of my table that might give you an idea. 

Thanks in advance for your support.

Best regards

Shafiq