cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pkoletsi_bi Occasional Visitor
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

 

matrix_pivot.JPG

How can i do this?

 

Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
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.

 

output.PNG

 

Hope this can help you.

 

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.
1 REPLY 1
Highlighted
Community Support Team
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.

 

output.PNG

 

Hope this can help you.

 

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.