Formula's within a table?

[RickOShay]

Hi

I have created a table in Power BI Desktop and have dropped some fields into that report, which I am happy with. I want to add another column, but be able to do some formulas but I am unsure of how to do that.

Specifically, what I was trying to do is common size the data There is a list of values and a SUM at that bottom, I wanted to divided each value by the sum so that I could see the percentage of each value of the total. How would I go about doing that?

Thanks,

[vicky_ · Accepted solution]

You can try duplicate the sum field on the table then just choose to show value as percent of grand total? That saves you having to do any new columns or measures.