How to calculate percentage share of a metric for different values of dimensions?

[mohammad-saber]

Hi, 

Thanks for reading my question. 

I have a Power BI report for Energy Retailer data as shown below:

There are several slicers at the left side. 

I want to add a new bar chart which shows the Market Share for every retailer, like below:

The calculation method will be:

1) Calculate the sum of Customer Numbers for all Retailers, and for the value of dimensions selected by slicers. 

2) For every retailer, Market Share is the sum of the Customer Number of that Retailer (for the value of dimensions selected by slicers) divided by the total Cusotmer Number calculated in step 1. 

Here is the sample report and data: URL

---------------------------------------------

In addition, I want to show the Market Share as a seperate chart for a specific Retailer like below (3rd page of the report). Note that user can select several quarters. 

---------------------------------------------

Please note that the data source itself has a field named Market Share, but data is not accurate. So I need to calculate Market Share.

Thanks for your help.