Help with Gauges - Percentages

[johnbradbury]

Could someone please point me in the right direction on this. I have a column with 5 distinct values, 2 that are considered positive, and 3 that are negative. I need to calculate the total number of positive responses as a percentage of all entries.

[Sean]

@johnbradbury

Create a Measure to count all

Total Values = COUNTROWS ( 'Table' )

Then another Measure to Calculate the % Positive

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

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

Then create you gauge and add the Measure to the Values

Here's the Result...

 Hope this helps!

[johnbradbury]

Thank you for responding so quickly.

% of responses which are positive = DIVIDE (CALCULATE ( [Total Responses], FILTER( 'Sheet1', 'Sheet1'[Satisfaction Level] ) ), )

The responses I want to count which are positive are: Excellent, Good

[Sean · Accepted solution]

@johnbradbury

% of responses which are positive =
DIVIDE (
    CALCULATE (
        [Total Responses],
        FILTER (
            'Sheet1',
            'Sheet1'[Satisfaction Level] = "Excellent"
                || 'Sheet1'[Satisfaction Level] = "Good"
        )
    ),
    [Total Responses],
    0
)

You can also do this

% of responses which are positive =
DIVIDE (
    CALCULATE (
        [Total Responses],
        'Sheet1'[Satisfaction Level] IN { "Excellent", "Good" }
    ),
    [Total Responses],
    0
)

Hope this helps!

[johnbradbury]

Thanks Sean, you're a star!