Haydn Richardson on 06 Dec 2014 03:56:36
In addition to sum, average, min, max etc. I'd like an option in values for % of total
Administrator on 01 Jun 2016 05:13:31
We shipped % of grand total as a part of quick calcs in the May release of Power BI desktop. Next up, % of column and % of row total. Give it a try and let us know what you think. For info on how to use it, check out the blog post covering our May feature releases: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-update-feature-summary/
- Comments (78)
RE: Percent of total
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.
RE: Percent of total
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.
RE: Percent of total
Why wouldn't this be part of the basic design? Statistics require percentages.... or am I crazy?
RE: Percent of total
I am actually surprised this is not an option yet!
RE: Percent of total
Very useful function... when can it be ready?
RE: Percent of total
even good old excel can do this ...
RE: Percent of total
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.
RE: Percent of total
Can anyone tell me how we can get the % of total when im using DirectQuery mode to a SQL database?
RE: Percent of total
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.
RE: Percent of total
%OfTotal=(Table[TotalAmount])/CALCULATE(Table[TotalAmount],ALLSELECTED () )*100
Note: TotalAmount is the measure in my dataset.