Percentage calculation in a row context

[JustinDoh1]

I am sharing my Pbix file here;

I am trying to come up with percentage of data displayed on a separate column as illustrated below.

I am only calculating % using output of two columns (Percentage Qualified A & Percentage Qualified B).

The values are coming from Count.

So, the expected output are 90.5 % (for Client_ID 129532) and 86.9% (Client_ID 129533).

How do we go about doing this?

Thanks.

[AlexisOlson · Accepted solution]

Try this (table and column names abbreviated for readability):

% Qualified =
DIVIDE (
    CALCULATE (
        COUNT ( vw[Client_ID] ),
        vw[Are_you_vaccinated] IN { "Percentage Qualified A", "Percentage Qualified B" }
    ),
    CALCULATE ( COUNT ( vw[Client_ID] ), REMOVEFILTERS ( vw[Are_you_vaccinated] ) )
)

[JustinDoh1]

@AlexisOlson Thanks. I will create a separate post. I think it might be better if I unpivot data of "Are_you_vacc..".

[AlexisOlson · Accepted solution]

Try this (table and column names abbreviated for readability):

% Qualified =
DIVIDE (
    CALCULATE (
        COUNT ( vw[Client_ID] ),
        vw[Are_you_vaccinated] IN { "Percentage Qualified A", "Percentage Qualified B" }
    ),
    CALCULATE ( COUNT ( vw[Client_ID] ), REMOVEFILTERS ( vw[Are_you_vaccinated] ) )
)

[JustinDoh1]

@AlexisOlson Thanks for help. How do I show these values in a column?

[AlexisOlson · Accepted solution]

They won't neatly go into another column in your existing visual since that matrix uses [Are_you_vaccinated] for the columns already. I'd suggest asking a separate question to resolve any layout issues.