Percent of multiple text values in a column

[AshleyRenee]

Hello, 

Is there a way to use this formula but of multiple text values? 

= (Calculate(counta('Table'[Response]), 'Table'[Response] = "Yes")) / (Countrows ('TableName')

So instead of yes, I want to find the percent of the following text values: 

AA - Other

AA - iLead

AB 

Your help is appreciated.

[MFelix]

Hi @AshleyRenee 

If you have that column on the visualization then you can do the following:

= DIVIDE((Calculate(counta('Table'[Response]), 'Table'[Response] in  VALUES('Table'[Response]))) , (Countrows ('TableName'))

If you want to hard coded you can do:

=DIVIDE( (Calculate(counta('Table'[Response]), 'Table'[Response] in {"AA - Other", "AA - iLead", "AB"}) , (Countrows ('TableName'))

[AshleyRenee]

Hello! 

Thank you! I tried doing the foruma for the hard code. 

%referralstoAnyWhere = DIVIDE((CALCULATE(COUNTA('ReferralsToAnywhere'[realogy_group]), 'ReferralsToAnywhere'[realogy_group] in {"AA - iLead", "AA - Other", "AB"}), (COUNTROWS('ReferralsToAnywhere'ReferralsToAnywhere))

But am getting this error. 

Operator or expression '( )' is not supported in this context.

[MFelix · Accepted solution]

Hi @AshleyRenee ,

You had the ( on the incorrect place try the following formula:

%referralstoAnyWhere =
DIVIDE (
    (
        CALCULATE (
            COUNTA ( 'ReferralsToAnywhere'[realogy_group] ),
            'ReferralsToAnywhere'[realogy_group] IN { "AA - iLead", "AA - Other", "AB" }
        )
    ),
    COUNTROWS ( 'ReferralsToAnywhere'[ReferralsToAnywhere] )
)