Forum Discussion
Market Share
Hello Everyone,
i have a table like the following :
| Company | Category | Month | Year | Value_€ | Volume_kg | Country | Region |
| CompanyA | S1 | jan | 2021 | 114 | 100 | Spain | Nord |
| CompanyB | S1 | feb | 2021 | 200 | 150 | Spain | South |
| CompanzC | F | jun | 2021 | 235 | 45 | France | East |
| CompanyD | F | jun | 2021 | 250 | 45 | France | East |
| CompanyW | B2 | may | 2021 | 200 | 50 | France | South |
| CompanyA | B2 | may | 2021 | 200 | 45 | Spain | East |
i would like to be able to visualize the a matrix as following, where as use a filter like so
to show the market share by category, country, region and company
| jan | feb | mar | jun | jul | … | Dec | YTD | |
| CompanyA | 2% | 3% | 2% | 2% | 2% | … | - | 3% |
| CompanyB | 2% | 3% | 1.3% | 3.3% | 2.1% | … | - | 2.5% |
| CompanyC | … | - |
i would like to realize this with DAX, but i lack a deeper knowledge DAX and would appreciate any help.
Regards
3 Replies
- v-easonf-msft
Community Support
Hi, Anonymous
Can you explain your requirements in more detail?
I can't understand your desired outcome.
Best Regards,
Community Support Team _ Eason Thanks v-easonf-msft,
Input data: so the given dataset looks like this:
Desired Outcome: i want to create a table or matrix vizual like this:
with the following slicers:
i hope i could make it clear. Thanks again for taking time
- v-easonf-msft
Hi, Anonymous
You provided me with the same screenshot, which makes no sense.
I simply cannot figure out how you calculated the market share due to the lack of data you provided.
That is why I would like you to be more specific in explaining the logic of the calculation.
Best Regards,
Community Support Team _ Eason
