Market Share table by brand

[Busno]

Dear all,

I want to create a table that look like this.

How can I make share by brand?

Thank you

[amitchandak · Accepted solution]

Try

Market Share = divide(sum(Table[Sales]), calculate(sum(Table[Sales]),allselected(table)))

OR

Market Share = divide(sum(Table[Sales]), calculate(sum(Table[Sales]),all(table)))

[Busno]

Dear amitchandak,

It's work. Thank you very much