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
Community Champion
9 years ago

Anonymous

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
      Sean
      Community 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!