Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello!
I'm working on a project and as one of the visuals I wanted to make a card that will show the viewers- a market share of biggest competitor. Obviously I have a measure counting market share ready and one of the columns in the main table shows the brands assigned to individual sales. I also have a ranking of every brand market share by country and date which is ready, if that would help somehow.
I thought I could make such a measure (for this card) that would show the 1st place in the ranking, but if my brand f.ex Ferrari is 1st in some country or in some period of time it would show the 2nd biggest player. In my mind it's pretty basic but I just haven't found any solution to this problem or I excluded my brand wrongly and the whole market share was counted without taking the numbers of my brand. If you have an idea on how to solve this problem I will be glad to hear that.
Thank you for your time 🙂
@mzienowicz99 a sample data and expected output can accelerate solution to this.
That's a sneak peak on my main table and I also have ready measures counting market share, as well as rank measure:
Hi,
Share a small dataset (which can be pasted in MS Excel) and on that dataset, show the expected result under various scenarios.
Put a filter on that card visual, select "Top N" and find the top 1 company by your market share value. (including a screenshot of a similar filter from my environment)
Unfortunately, by doing it this way it will show me always the first place and I want the 2nd place to be shown when my brand is 1st. So as I described earlier, the biggest competitor!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
59 | |
57 |