Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Matrix - changing total and dividing two rows

Hi 

 

I've got a matrix P&L , with the first line being our volumes. I'm looking to calculate CPL : dividing the volumes line with our COGS line in the matrix. 

 

Also is there a way to remove the total? As the total includes the volumes which shouldn't be included as my total P&L number

 

Thanks in advance!

 

Need Help
  • lc_finance's avatar
    lc_finance
    6 years ago

    Hi Anonymous ,

     

     

    To calculate CPL you can create a new calculated measure. 

    The formula could look like this:

     

    CPL = CALCULATE(
   SUM(Table[Values]),
   Table[P&L] = "Volumes"
) /
CALCULATE(
   SUM(Table[Values]),
   Table[P&L] = "COGS"
)

    For removing the Total, you can turn it off in the visualization format:

     

     

    Let me know if this answers your questions

     

    Regards,

     

    LC

    Interested in Power BI templates? Check out my blog at www.finance-bi.com

     

1 Reply

  • lc_finance's avatar
    lc_finance
    Icon for Solution Sage rankSolution Sage
    6 years ago

    Hi Anonymous ,

     

     

    To calculate CPL you can create a new calculated measure. 

    The formula could look like this:

     

    CPL = CALCULATE(
   SUM(Table[Values]),
   Table[P&L] = "Volumes"
) /
CALCULATE(
   SUM(Table[Values]),
   Table[P&L] = "COGS"
)

    For removing the Total, you can turn it off in the visualization format:

     

     

    Let me know if this answers your questions

     

    Regards,

     

    LC

    Interested in Power BI templates? Check out my blog at www.finance-bi.com