Display a percentage value on its own

[speterson]

Good day,

I am looking for a way to display the percentage of a chart on its own - example

I would like for it to display the % value of one column on its own - example below 

Thank you for you help!!!

[TheoC · Accepted solution]

Hi @speterson 

You need to do a few measures:

The first is to sum all of the amounts fromt he column:

Total Amount = SUM ( 'Table'[Column] ) 

The second is to calculate the specific values of the category that make up the 2.59%:

Total Amount SLA Missed = CALCULATE ( [Total Amount] , FILTER ( 'Table'[Category Name] = "SLA Missed" ) )

The third will divide the second measure by the first to return the 2.59%:

SLA Missed % = [Total Amount SLA Missed] / [Total Amount]

Now, you can do it is one measure as follows as well if you want:

SLA Missed % = 

VAR _1 = CALCULATE ( SUM ( 'Table'[Amount] , FILTER ( 'Table'[Category Name] = "SLA Missed" ) )
VAR _2 = SUM ( 'Table'[Amount] )
VAR _3 = _1 / _2

RETURN

_3

Make sure to format the measure as a Percentage using the % button in the top ribbon.

Hope this helps!

Theo