Calculate Margin when Sales and cost are in the same column

[jalaomar]

Hi all, 

I need help to calculate Margin, when I have both sales and cost in the same column.

I tried with the following measure, but no values are showing when I put the measure into a visual.

Margin = CALCULATE(

SUM('P&L'[05.2019]); 'P&L'[Account Grp 3] = "Net Equipment Sales")

-

CALCULATE(

SUM('P&L'[05.2019]); 'P&L'[Account Grp 3] = "Net Equipment Cost")

[tex628]

If you get nothing from that margin calculated i's leading me to believe that something is wrong with that account filter.

Start by creating seperate measures for sales and cost and make sure that they are working.

If you're getting nothing there, try calculating with the specific account instead of the groups. 

Let me know how it goes. 

/ J

[jalaomar]

You were right, the specific account needed to be different.

Thanks for the input!