none
Dates and using COUNTAX with two filters

    Question

  • I have a table (Project Issues) that I want to calculate the number of days since the last update as well as calculate the number of these records for active projects in two separate fields LastUpdateDays  and CountPastDue

    I can calculate the days using LastUpdateDays = today() - 'PROJECT ISSUES'[Modified Date]

    I can count the number of rows/records in the table that exceed 30 days 

    CountPastDue = COUNTAX(FILTER('PROJECT ISSUES',[LastUpdateDays]>30),[LastUpdateDays])

    However, when I attempt to add another filter (ACTIVE) I am not getting the results I should

    OverTimeCountx = CALCULATE(COUNT('PROJECT ISSUES'[LastUpdateDays]),FILTER('PROJECT ISSUES',[LastUpdateDays]>30) || ('PROJECT ISSUES',[Status]="(1) Active"), [LastUpdateDays])

    What am I doing wrong?

    Regards, Jim


    jim neal


    Friday, April 26, 2019 12:29 PM

All replies