calculate ratio on some intermediate/filtered table

[alexpantex]

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

[lbendlin]

That's a zero sum game unless you add the manufacturer to your output table.