I'm relatively new to DAX and stuck on a particular problem. I would like to build a line chart that shows the percentage of market share of all my products for each month. I have include filters on the page for Country, Divison, Product Line and Month.
I need to calculate the percentage of market share by dividing (revenue/market size); however I do not know how to add that to the whole formula with the filters. (The whole market are the three countries)
It would need to dynamically recalculate with the context of the filter so that only data after the filter is included. And when no filter is selected then I have the total market share of our market.
I have tried various CALCULATE, SUMX, Calculated Table functions with little success.
Sample data is below and any help is very much appreciated, I know tha market share column should be calculated in power bi
Thank YOU
| Country | Division | Product Line | Market Size | Revenue | Market Share |
| Mexico | Dental | Red | 100.00 | 50.00 | 50% |
| Mexico | Dental | Green | 95.00 | 45.00 | 47% |
| Mexico | Cosmetics | Yellow | 125.00 | 100.00 | 80% |
| Mexico | Cosmetics | Pink | 70.00 | 30.00 | 42% |
| Argentina | Dental | Red | 50.00 | 10.00 | 20% |
| Argentina | Dental | Green | 45.00 | 5.00 | 11% |
| Argentina | Cosmetics | Yellow | 80.00 | 45.00 | 56% |
| Argentina | Cosmetics | Pink | 70.00 | 5.00 | 7% |
| USA | Dental | Red | 200.00 | 150.00 | 75% |
| USA | Dental | Green | 130.00 | 85.00 | 65% |
| USA | Cosmetics | Yellow | 250.00 | 200.00 | 80% |
| USA | Cosmetics | Pink | 140.00 | 100.00 | 71% |
