Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Help with Gauges - Percentages

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 ...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    Anonymous

    % 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!:smileyhappy:

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago

Anonymous

% 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!:smileyhappy:

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Thanks Sean, you're a star!