How to create a Gauge that shows Percentage

[GreeffR]

Good day,

I am experiencing an issue whereby I cannot seem to get the Gauge to accurately represent a percentage.

When formatting my measure using the FORMAT function, the visual does not allow me to add it to the  "VALUE" section of the Gauge.  Removing this does allow me to add it to the value column, (the same happens with the "Maximum" value).  However, I want it to be represented as a percentage of total.  When using the "Show as percentage of total", both show as 100%.

Please see the formula below of the percentage I wish to represent using a gauge chart.

AdoptionRate = (CALCULATE(COUNT('Table'[QuestionSetInstanceAnswerId]),

'Table'[ComputedStatus] = {"Completed"},

'Table 2'[QuestionTypeName] = {"Control"}))

/

(CALCULATE(COUNT('Table'[QuestionSetInstanceAnswerId]),

'Table'[ComputedStatus] = {"Completed"} ||

'Table'[ComputedStatus] = {"LockedOut"} ||

'Table'[ComputedStatus] = {"Overdue"},

'Table 2'[QuestionTypeName] = {"Control"}))

I have also looked at using calculated columns in the table view to create one , or two seperate calculated columns (whereby I split the calculation)  However, the same result can be seen.

Please can anyone assist?

[Anonymous · Accepted solution]

Hi Try This,

Create a Measure to count all

Total Values = COUNTROWS ( 'Table' )

Then another Measure to Calculate the %

% =
DIVIDE (
    CALCULATE ( [Total Values], FILTER ( 'Table', 'Table'[Value] > 0 ) ),
    [Total Values],
    0
)

After you create the % Measure - select it - go to the Modeling tab and Format it as Percentage

Then create you gauge and add the Measure to the Values

HOPE THIS WILL HELP