hide rows with 0 if all other columns are blank

[WTAS80486]

I am using this calculation

DT=

var _DT=CALCULATE(SUM(Table [Hours]),Table[Date(Start)]>=MIN('ReadingDate'[Reading Date]), Table[Date(Start)]<=MAX('ReadingDate'[Reading Date]))

return

IF(ISBLANK(_DT),0,_DT)

To populate 0 if blank, but this is also pulling those rows which have all other fields blank

How can i exclude these rows from display

[Chew_WenJie · Accepted solution]

Hello, i think you can try to select is not blank at the advanced filtering of either Run Hours or Total Hours column

hope this can help you.

[WTAS80486]

@Chew_WenJie Thanks!