DAX Help - Repeating amount on column

[ronaldbalza2023]

Hi everyone, I have these dax measures that is worked fine. However, when I place a category on the column, it gives me a weird repeating amount. How to not show the repeating amount? Thanks in advance. 

P&L = 
CALCULATE (
    SUM ( 'Invoices'[Line Amount Calculation] ),
    FILTER (
        'Accounts',
        Accounts[Class] = "Revenue"
            || Accounts[Class] = "Expense"
    )
) - [P&L - Credit Notes] + [P&L (Journals)]

P&L - Credit Notes = 
CALCULATE (
    SUM ( 'Credit Notes'[Line Amount Credit Note Calculation] ),
    FILTER (
        'Accounts',
        Accounts[Class] = "Revenue"
            || Accounts[Class] = "Expense"
    )
)

P&L (Journals) = 
CALCULATE (
    0 - ( SUM ( 'Journals'[Net Amount] ) ),
    FILTER ( 'Journals', 'Journals'[Split] = "JOURNALS" ),
    FILTER (
        'Accounts',
        Accounts[Class] = "Revenue"
            || Accounts[Class] = "Expense"
    )
)

[amitchandak · Accepted solution]

@ronaldbalza2023 , the invoice table is not joined with the table used in row or column. Check the join