Dax calculation to include blank rows

[eng_123]

Hi All I am trying a dax calculation to below scenario. Seems to work fine for nonblank rows but its excluding the blank rows.

CALCULATE (

    MAX ( 'Table'[Product Delivery Status] ),

    FILTER ( 'Table', 'Fact'[Product Delivery Date] = MAX ( 'Fact'[Product Delivery Date] ) )

)

Dataset:

Product	Product Delivery Status	Product Delivery Date
Apples	Delivered	10/05/2023 23:08
Apples	Delivered	10/05/2023 21:12
Strawberry
Pear
Orange	Failed	10/05/2023 21:12
Orange	Delivered	10/05/2023 21:12

Current Result:

Product	Product Delivery Status	Product Delivery Date	Dax Calculation Required
Apples	Delivered	10/05/2023 23:08	Delivered
Orange	Failed	10/05/2023 21:12	Failed

Desired Result:

Product	Product Delivery Status	Product Delivery Date	Dax Calculation Required
Apples	Delivered	10/05/2023 23:08	Delivered
Strawberry
Pear
Orange	Failed	10/05/2023 21:12	Failed

[FreemanZ]

you may also try with a calculated table like:

Table = 
ADDCOLUMNS(
    VALUES(data[Product]),
    "Status",
    CALCULATE(MAX(data[Product Delivery Status])),
    "Date",
    CALCULATE(MAX(data[Product Delivery Date]))
)

it worked like:

[FreemanZ]

hi @eng_123 

not sure if i fully get you, you can plot the table visual directly like:

0 code.