Calculate value from a summarize table

Hi camargos88 ,

Maybe this can help you. You could reference it to modify your formula based on the actual situation.

Income =
CALCULATE (
    SUM ( 'Table'[Total] ),
    FILTER (
        ALLEXCEPT ( 'Table', 'Table'[Category], 'Table'[Month] ),
        'Table'[Column] = "Income"
    )
)

Expense =
CALCULATE (
    SUM ( 'Table'[Total] ),
    FILTER (
        ALLEXCEPT ( 'Table', 'Table'[Category], 'Table'[Month] ),
        'Table'[Column] = "Expense"
    )
)

NOI = [Income] + [Expense]

% NOI = DIVIDE([NOI],[Income])

And you could take a look at the document: Use conditional formatting in tables to try customizing the background color.

Conditional formattingResult

You could download the attachment to learn more details.