topic Dax calculation to include blank rows in DAX Commands and Tips

Dax calculation to include blank rows

eng_123 — Fri, 12 May 2023 00:00:04 GMT

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

Re: Dax calculation to include blank rows

FreemanZ — Fri, 12 May 2023 02:32:10 GMT

hi eng_123

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

0 code.

Re: Dax calculation to include blank rows

FreemanZ — Fri, 12 May 2023 02:33:31 GMT

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: