Matrix - changing total and dividing two rows

[Anonymous]

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!

[lc_finance · Accepted solution]

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