Dax Calculation

[raju8004]

im not able to make it dynamic for below calculation based on date range filter its not changing can any one help

Pending Incidents more than one day = IF(ISBLANK(CALCULATE(DISTINCTCOUNT('Incident Monitoring'[number]),'Incident Monitoring'[incident_state] in {"In Progress","On Hold"},'Incident Monitoring'[opened_at]<TODAY()-1)),0,CALCULATE(DISTINCTCOUNT('Incident Monitoring'[number]),'Incident Monitoring'[incident_state] in {"In Progress","On Hold"},'Incident Monitoring'[opened_at]<TODAY()-1))

[Anonymous]

Hi @raju8004 ,

Sorry but can you provide some sample dataset and your expected results? With DAX alone, I have no way of knowing what your problem is.

Best Regards,
Dino Tao

[raju8004]

CountPendingInProgress =

VAR MinDate = MIN('Date'[Date])

VAR MaxDate = MAX('Date'[Date])

RETURN

COUNTROWS(

    FILTER (

        'Incidents',

        'Incidents'[Status] IN { "In Progress", "Pending" } &&

        'Incidents'[Date] >= MinDate &&

        'Incidents'[Date] <= MaxDate

    )

)