What exact DAX formula for filter positive numbers in measure

[Sravanthipasala]

Good day .

In the snippet below, I'm attempting to separate positive numbers from DEP delay and Arr delay using a DAX formula in a measure.

What is teh Exact DAX formula to filter only postive numbers from the column??

Requirement -Total number of flights delayed (Arr+Dep)

please help urgently.

[FreemanZ · Accepted solution]

hi @Sravanthipasala 

try like:

DelayCount =

COUNTROWS(

    FILTER(

        ALL(TableName),

        TableName[DEP_DELAY]>0

           || TableName[ARR_DELAY]>0

    )

)

[Sravanthipasala]

hi @FreemanZ

Looks like I got it right. Thank you so much for your help.