Matrix - Use total to calculate a column

[pkoletsi_bi]

Hi, i am new to this and i would appreciate if anyone can help me with the following.

I have used matrix to create a pivot table as shown below and i want to create a column that will be the cell value/total value 

e.g. 1-1 --> 20/99

2-1-->3/99

3-1-->2/99

How can i do this?

Thank you.

[v-piga-msft · Accepted solution]

Hi @pkoletsi_bi,

You could create a measure with the formula below.

Measure = CALCULATE(MAX('Table1'[Value]))/CALCULATE(SUM(Table1[Value]),ALL('Table1'))

Here is the result.

Hope this can help you.

Best  Regards,

Cherry

[Anonymous]

Hey what about the below metrics:-

Numerator(Values of Column(Impl Axis)/Constant Denominator (99 e.g. grand total of Total column)