Profit and Loss Statement

Hi GuestUser, 

Please create a calculated table with DAX below: 

Table =
UNION (
    SUMMARIZE (
        'Master table - Dimension',
        'Master table - Dimension'[Level6],
        "Actual", SUM ( 'Fact'[Amount] )
    ),
    ROW (
        "Level6", "Profit Before Depreciation",
        "Actual", CALCULATE (
            SUM ( 'Fact'[Amount] ),
            FILTER (
                'Master table - Dimension',
                'Master table - Dimension'[Level6] = "Sales"
                    || 'Master table - Dimension'[Level6] = "COGS"
            )
        )
    ),
    ROW (
        "Level6", "Profit After Depreciation",
        "Actual", CALCULATE (
            SUM ( 'Fact'[Amount] ),
            FILTER (
                'Master table - Dimension',
                'Master table - Dimension'[Level6] = "Sales"
                    || 'Master table - Dimension'[Level6] = "COGS"
            )
        )
            - CALCULATE (
                SUM ( 'Fact'[Amount] ),
                FILTER (
                    'Master table - Dimension',
                    'Master table - Dimension'[Level6] = "Depreciation"
                )
            )
    )
)

Best Regards,
Qiuyun Yu