P&L Help

[akhtar0507]

Hello,

I have finally got my report to ressemble an income statement and all my measures are working fine individually. However, when I am summing my cost of sales and cost of sales B, it is returning blank as I am assuming the total cost of sales does not have any rows in the current context. 
Here is my formula that I am trying since few days. Can you please help me out?

Income Statement Amount =

VAR _currentItem = SELECTEDVALUE('GL Segment'[GL Grouping])

RETURN

SWITCH(TRUE(),

_currentItem = "Sales", [GL Total Sales],

_currentItem = "Cost of Sales",[GL Cost of sales Only],

_currentItem = "Cost of Sales B", [GL Cost of sales B],

_currentItem = "Total Cost of Sales", [GL Cost of sales Only] +  [GL Cost of sales B]

)
However, individually my formula is working fine, but the problem arises when I am trying to display it in my matrix. The total is good but the measure Total Cost of Sales is returning blank.

 

[PaulDBrown]

what are the measures in the total calculation?

[akhtar0507]

Hello PaulDBrown,

The total contains Coat of sales B and Cost of Sales Only.

Thank you for helping. 

[PaulDBrown]

Right, but can post the  code for each measure?

[akhtar0507]

GL Cost of sales Only =

VAR _glGrouping = CALCULATETABLE( 'GL Segment', 'GL Segment'[GL Grouping] = "Cost of Sales")

VAR _netGL = [Net GL]

return

CALCULATE([Net GL],_glGrouping)

GL Cost of sales B =

VAR _glGrouping = CALCULATETABLE('GL Segment', 'GL Segment'[GL Grouping] = "Cost of Sales B")

VAR _netGL = [Net GL]

return

CALCULATE([Net GL],_glGrouping)

and for [Net GL] = sum(Debit) - sum(Credit) from the GL table.

[PaulDBrown · Accepted solution]

Try:

_currentItem = "Total Cost of Sales", CALCULATE( [GL Cost of sales Only], ALL ( GL Segment )) +  CALCULATE ( [GL Cost of sales B], ALL ( GL Segment) ))

[akhtar0507]

Hello PaulDBrown,

Big thumps up for your input.

Works like a charm 😄