Percent of total

[haydnr]

In addition to sum, average, min, max etc. I'd like an option in values for % of total

[9188040d-6c6436]

I am actually surprised this is not an option yet!

[fwnb]

Very useful function... when can it be ready?

[gabriam]

Certanly should be part of the basic design. Its almost impossible do not use %. I'm wainting for this, like the numbers at filled map chart.

[peter_bontekoe]

even good old excel can do this ...

[erinapiazza]

You can use a measure to create a percentage until there's a better solution. It works just like Excel. Create a new measure, choose the percentage option from the "data type" dropdown in the tool bar. Then, create a new measure: =sum(total value)/=sum(divisible value). Your measure will then appear in the right column.

[jgodfl]

Why wouldn't this be part of the basic design? Statistics require percentages.... or am I crazy?

[mnawas2]

What if the values ar string like LETTERS (A, B,C)? How to we create a calculated column of for the percentages of these values? I have a list of letter grades and I need to create percentages.

[leonne_jones]

Can anyone tell me how we can get the % of total when im using DirectQuery mode to a SQL database?

[benjamin_peter1]

It would be great if we can use a chart and we can show the absolut value and the percentage value on the same chart. If there is a pie chart with 2 categories, the result should be like: Category 1: 150 (75%) Category 2: 50 (25%) or Category 1: 75% (150) Category 2: 25% (50) It would be nice if there are 1 or 2 flags to define the description with both values or with only one value.

[naeem_noor_maho]

I would assume that being able to present data in absolute or % would be a basic function and have been key in excel pivot tables for decades