Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi everyone,
I have one doubt that I'm not currently able to solve.
Let's say that I have a following table imported:
Category | Manufacturer | Brand | Sales |
A | M1 | B1 | 1 |
A | M2 | B2 | 2 |
B | M1 | B1 | 3 |
B | M2 | B2 | 2 |
What I'd need is to calculate by Category if Manufacturer M1, for example, had greater sales than competition and calculate ratio in how manu categories it had greater sales.
For example, in Category A M1 had lower sales so I'd flag it as 0 and in Category B it had greater sales so I'd flag it as 1 and then the ratio would be 50%.
Category | Sales_Flag |
A | 0 |
B | 1 |
Not sure if there is a way to do this in one go, or is it possible to create intermediary table with DAX to look like this and then just use CALCULATE to create ratio?
Any help, hint or resource would be helpful.
Thanks
That's a zero sum game unless you add the manufacturer to your output table.
User | Count |
---|---|
84 | |
71 | |
71 | |
68 | |
55 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |