Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
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
Hi, @Anonymous
Can you explain your requirements in more detail?
I can't understand your desired outcome.
Best Regards,
Community Support Team _ Eason
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |