cancel
Showing results for
Did you mean:
Occasional Visitor

## Matrix - Use total to calculate a column

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team

## Re: Matrix - Use total to calculate a column

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.

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Community Support Team

## Re: Matrix - Use total to calculate a column

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.