Percentage value in a separate column

[JustinDoh1]

This is similar question from my previous post, but has different column structure.

I am sharing my Pbix file here.

I am trying to come up with the Percentage of addition of these two columns (Percentage Qualified A & Percentage Qualified B) divide by Total as displayed in below:

So, expected output is having a separate column of "Percentage".

I have unpivotted the value from original file structure so, now it has one column of Attribute and one column of its Value.

I have a measure like this:

% Qualified_M =

    DIVIDE (

             CALCULATE ( COUNT ( vw_staff_summary_covid19_rpt[Client_ID] ),
           vw_staff_summary_covid19_rpt[Value]
          IN {
                 "Percentage Qualified A", "Percentage Qualified B"
               } 
),

CALCULATE ( COUNT ( vw_staff_summary_covid19_rpt[Client_ID] ),
                         REMOVEFILTERS (
                           vw_staff_summary_covid19_rpt[Value]
                             )
                    )
)

I am not sure how to modify this measure to show a separate column of %.

Thanks.

[JustinDoh1]

@smpa01 Thank for help.

How do I keep the current column structures and add the percentage as a new column?

Should I change the structure of data somehow?

It appears that when I tried the measure, it goes under the row of Count of Client_ID.

[smpa01]

@JustinDoh1 you need to write explicit measures and use that explicit measures in values. You can't have anything as Columns. Whatever you are currently showing under columns, you need to convert each of them into measures.

[JustinDoh1]

@smpa01 Thank you for your lead. Learned new concept today. Let me try and see if I could convert the values in to explicit measures. I have been trying with "unpivoting" colume of data recently, and I am wondering how I should strucutre the data now (in order to create "explicit measure").

[smpa01 · Accepted solution]

@JustinDoh1  you can use the followine measure

Measure =
DIVIDE (
    CALCULATE (
        COUNT ( vw_staff_summary_covid19_rpt[Client_ID] ),
        FILTER (
            VALUES ( vw_staff_summary_covid19_rpt[Value] ),
            vw_staff_summary_covid19_rpt[Value] = "Percentage Qualified A"
                || vw_staff_summary_covid19_rpt[Value] = "Percentage Qualified B"
        )
    ),
    CALCULATE ( COUNT ( vw_staff_summary_covid19_rpt[Value] ) )
)