Market Share using Tabular Editor

[brinky]

Good morning,

Any idea how to create a caclculation on Tabular Editor to get MARKETSHARE as per attached excel sample file.

My other calcluations listed below work like a charm, thanks to Marco Russo's video.

[negi007]

@brinky You can use your already created PY, PM and Current to calculate share% from total. You drag these measures in the value field and right clicking will allow you to change the values into % of grand total which is basically the share% from total

[brinky]

Thanks for your reply, unfortunately this doesn't wok when using calculations with Tabular Editor.

[amitchandak · Accepted solution]

@brinky , for % of total you need to Modify a measure like

divide([PY], calculate([PY], allselected(Table)))

[brinky]

Thanks, @amitchandak worked as required and as expected. 👏

Thank You