topic Formula calculating market share in DAX Commands and Tips

Formula calculating market share

Anonymous — Fri, 25 Feb 2022 14:46:44 GMT

Hi im trying to figure out a way to identify market shares for each day for each company + month to date and year to date.
I have a big data set with multiple companies and dates, but I will use this as a simple example:

I want my outcome to look something like this:

Any idéas? I will appriciate any help!

Re: Formula calculating market share

amitchandak — Fri, 25 Feb 2022 15:54:45 GMT

Anonymous , You can create a measure like

divide(sum(Table[Revenue]),calculate(sum(Table[revenue]), removefilters(table[Company]))

then use this measure with day, Month and Year in row of matrix visual

Adding MTD and YTD like that would be challenging

Re: Formula calculating market share

CNENFRNL — Sat, 26 Feb 2022 11:37:33 GMT

Formula worksheet formula is enough to deal with such simple question,

Re: Formula calculating market share

Anonymous — Tue, 01 Mar 2022 07:38:37 GMT

amitchandak works great, thank you very much!