Waterfall issue

Hi erihsehc,

You could try two ways.

Solution 1

Create a one to many relationship between 'Sheet1' and 'Sheet2' based on common field.

Create a simple measure like below. Add this measure into waterfall chart rather than a calculated column.

Measure amount = SUM(Sheet2[amount])

Solution2

Without any relationship between 'Sheet1' and 'Sheet2', create a measure like this, also, add this measure into waterfall chart.

Measure Amount2 =
IF (
    LASTNONBLANK ( Sheet1[Column1], 1 ) = "PAT Budget",
    [PAT budget],
    IF (
        LASTNONBLANK ( Sheet1[Column1], 1 ) = "Fty PBT",
        [Fty PBT],
        IF (
            LASTNONBLANK ( Sheet1[Column1], 1 ) = "SGA & Others",
            [SGA],
            IF ( LASTNONBLANK ( Sheet1[Column1], 1 ) = "Tax", [Tax] )
        )
    )
)

I have uploaded the modified .pbix file for your reference.

Best regards,
Yuliana Gu