Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Market Share

 

Hello Everyone,

 

i have a table like the following :

 

CompanyCategoryMonthYearValue_€Volume_kgCountryRegion
CompanyAS1jan2021114100SpainNord
CompanyBS1feb2021200150SpainSouth
CompanzCFjun202123545FranceEast
CompanyDFjun202125045FranceEast
CompanyWB2may202120050FranceSouth
CompanyAB2may202120045SpainEast

 

i would like to be able to  visualize the a matrix as following, where as use a filter like so 

daroox_4-1630953067480.png

to show the market share by category, country, region and company

 janfebmarjunjulDecYTD
CompanyA2%3%2%2%2%-3%
CompanyB2%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 3
Anonymous
Not applicable

Thanks @v-easonf-msft,

 

Input data:  so the given dataset looks like this:

daroox_0-1631201822197.png

 

Desired Outcome: i want to create a table or matrix vizual like this:

 

daroox_1-1631201888452.png

with the following slicers:

daroox_2-1631201912598.png

 

i hope i could make it clear.  Thanks again for taking time

 

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
Community Support
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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.