Trying to write Explicit Measure to calculate Percentage ( A / Total) in a new column

[JustinDoh1]

I am sharing my Pbix file here.

This is a similar issue that I had last two days, but I need some advice regards to creating explicit measure on data first in order to solve the issue. 

I have a data set (table) that has two columns as shown below:

I am trying to come up with percentage of Product A / total for different client.

So far, I have a matrix shown as below:

Matrix has following data structure:

I would like to have another column next to Total that has a percenage of Product A / Total:

I have a measure that calculates percentage but, it only goes under Values, not Columns:

% Product A =

DIVIDE

( CALCULATE ( COUNT ( Data[Client_ID] ),

Data[Product Type] IN { "Product A" } ),

CALCULATE ( COUNT ( Data[Client_ID] ), REMOVEFILTERS ( Data[Product Type] ) ) )

My question is:

How do I create Explicit mesure from my data set in order to have Percentage value shown as another column in Matrix?

Thanks.

[JustinDoh1]

@Jihwan_Kim Thank you Jihwan. You are great! Appreciated.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the sample pbix file.

All measures are in the sample pbix file.

Link to the sample pbix file