Calculate percentage of total for column

[lscoffield]

I have a table that I am reporting on that includes a column IsEmployed. The chart shows those employed (green) and not employed (red) for each year. 

I would like to display a percentage employed in each column for each year. Is this possible with Power bi? 

[Vvelarde · Accepted solution]

@lscoffield

Hi, try with this (modified accord to your tables and Fields)

%byType =
DIVIDE (
    CALCULATE ( COUNT ( Table1[Employee] ) ),
    CALCULATE ( COUNT ( Table1[Year] ), ALLSELECTED ( Table1[Employee] ) )
)

Regards

Victor

Lima - Peru

[lscoffield · Accepted solution]

How did you get the value to show in the column?

[Vvelarde · Accepted solution]

@lscoffield

Hi, try with this (modified accord to your tables and Fields)

%byType =
DIVIDE (
    CALCULATE ( COUNT ( Table1[Employee] ) ),
    CALCULATE ( COUNT ( Table1[Year] ), ALLSELECTED ( Table1[Employee] ) )
)

Regards

Victor

Lima - Peru

[lscoffield · Accepted solution]

How did you get the value to show in the column?

[Vvelarde · Accepted solution]

@lscoffield

Format Panel - Data Label ON.

[jthomson]

I can't see an obvious way to do this simply (unless you're happy for it to be a tooltip), you could try working around it by making a measure that calculates your percentage, adding that as another value to your chart, then setting your percentage to the same colour as the chart background (so it doesn't show up) and customising the data labels so that your employed/unemployed labels are turned off but your percentage is turned on.