topic Re: DAX calculate market share (% value) of the category per vendor in DAX Commands and Tips

DAX calculate market share (% value) of the category per vendor

Pedro14 — Wed, 17 Nov 2021 08:46:33 GMT

Hi,

I would like to calculate the market share (% value) of the category per vendor.

As per below, what is the % value of the total spend per color per vendor?

Any help would be appreciated.

Her is the data table:

Vendor Name	Color	Spend$
x	Blue	10
y	Blue	30
z	Blue	20
y	Red	40
x	Red	20
z	Red	50
Total		170

Color	Spend$
Blue	60
Red	110
Total	170

Result:

Vendor Name	Color	% of Spend per Color per vendor
x	Blue	17%
y	Blue	50%
z	Blue	33%
x	Red	18%
y	Red	36%
z	Red	45%

Re: DAX calculate market share (% value) of the category per vendor

VahidDM — Wed, 17 Nov 2021 09:08:19 GMT

Hi Pedro14

Try this measure:

Measure = Var _TotalC = CALCULATE(sum('Table'[Spend$]),filter(ALL('Table'),'Table'[Color]=max('Table'[Color]))) Var _SC = max('Table'[Spend$]) return _SC/_TotalC

Output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

Re: DAX calculate market share (% value) of the category per vendor

Pedro14 — Fri, 19 Nov 2021 14:07:17 GMT

Thanks a lot. It works!