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('Incid...
Need Help
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

    )

)