Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Anonymous,

     

    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

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous,

 

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's avatar
Anonymous
Not applicable
7 years ago

Hey what about the below metrics:-

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