Forum Discussion

Lolwife1966's avatar
Lolwife1966
Frequent Visitor
5 years ago

Measure required to count overdue orders

New to Power BI so please be gentle...   I have a table for outstanding orders - it contains a 'date expected' field and a 'hold status' field. An order is classed as overdue if the 'date expected...
Tanushree_Kapse's avatar
Tanushree_Kapse
Icon for Impactful Individual rankImpactful Individual
5 years ago

Hi Lolwife1966 ,

 

Try this measure:

 

Measure = COUNTROWS(FILTER('Table',ISBLANK([Hold Status]) && [Date expected]<TODAY()))

 

Mark this as a solution, if I answered your question.

Thanks 

  • Lolwife1966's avatar
    Lolwife1966
    Frequent Visitor
    5 years ago

    Thanks for that, I couldn't get that to work.

    The following seems to do the trick:

    Measure = COUNTROWS(FILTER('Table',[Hold Status]="" && 'Table'[Date expected]<TODAY()))