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 positive responses as a percentage of all entries.

 

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:

4 Replies

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity 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
        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: