Row percentage of a single row in same table

[depple]

Hi,

Relatively newbie in Power BI here. I have grind to a halt on an issue that I have no idea on how to solve.

I have huge table of weekly data of a few product categories (not the entire market) and the total market, simplified below. I would like to create a measure that calculates a percentage share of "Total Market". Or, maybe there are better ways than measures to solve this?

Product category	Value	% Share
A	10	1,7 %
B	20	3,3 %
C	30	5,0 %
Total Market	600	100,0 %

Thanks in advance for any assistance.

/depple

[Ashish_Mathur]

Hi,

In your actual PBI file, won't the Total Market row be a summation of the individual values appearing in the column above?  If not, then how do you get the value for the Total market row.

[depple]

Ashish,

It is actually about the source of the data and the row limitations in Excel. I have to limit the extraction to aggregating the market to a total.

I will look for another angle than my current dataset.

[v-jiascu-msft · Accepted solution]

Hi @depple,

You mean you do the work in Excel? Maybe you can do it simply as the snapshot shows.

Best Regards,

[depple]

The total is a part of the category data, not total for column in the dataset.

As it appears that there are no obvious solutions for my initial problem, I will try to work on my dataset instead, and then see if I can tweak it to do it your way.

Thanks!

/depple

[parry2k]

@depple you can surely write a measure to achieve this or look at the quick measure gallery and it will have the calculation to achieve it.