Count results of measure by other measure

[pawelj795]

Hi,
I have below a part of my shipment table.
Currently, I'm evaluating how much shipment is overdue and how much is on time.
If the date confirmed is later than the date requested, then the line of order is overdue.

My question is 
How to count how many order lines are overdue and how many are on time in a particular month and show it on a chart?

I have a date table ofc.

[amitchandak · Accepted solution]

@pawelj795 , Create a measure like

countx(filter(summarize(Table,Table[SalesID],Table[IREM_ID],"_1",[Date diff Timeline]),[_1]<0),[SalesID])

[pawelj795]

Thanks @amitchandak 

That's what I've been looking for.

By the way, just out of curiosity, when using COUNTAX instead of COUNTX would matter?

[pawelj795]

I have one additional request.

How to format font color in my text value on measure?
I mean when measure return "overdue" the font should be red, and when measure return "on time" the font should be green.