Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Dax Calculation

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))
Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago


    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

        )

    )

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    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