Forum Discussion

matrix_user's avatar
matrix_user
Icon for Helper III rankHelper III
3 years ago
Solved

Count rows with conditions based on two columns.

Hello,   I am looking for help for a DAX expression (measure) that would allow me to count rows with the condition that it has a start date and no end date only. Based on the example bellow the DAX...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi matrix_user 

    please try

    Count =
COUNTROWS (
    FILTER (
        'Table',
        NOT ISBLANK ( 'Table'[Start Date] ) && ISBLANK ( 'Table'[End Date] )
    )
)
Jayee's avatar
Jayee
Icon for Responsive Resident rankResponsive Resident
3 years ago

Hi Matrix_user

 

here the Measure formula for your query

Count with End Date = COUNTX('Table','Table'[End date])
Count without End Date = COUNTX('Table',IF(ISBLANK('Table'[End date]),1))