Market Share

[Anonymous]

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  

[Anonymous]

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

[v-easonf-msft]

Hi, @Anonymous 

Can you explain your requirements in more detail?

I can't understand your desired outcome.

Best Regards,
Community Support Team _ Eason