DAX for new Measure to calculate rows where status = Open and Past deadline

[Anonymous]

Hi

 I would like to create a filter or a new measure which will provide the count of Total rows where Status = Open and date in Deadline column = before today's date. Can you please help me write a query for this?

I created a visual Card which currently has total count of rows. I was thinking I would add a New Measure on top of this.

many thanks,

[parry2k]

@Anonymous add a measure something like this

Total Open Order Before Today = 
CALCULATE( 
COUNT( Table[Order Number], 
Table[Status] = "Open", 
Table[Order Date] < TODAY() 
)

[Anonymous]

[parry2k]

@Anonymous you didn't gave the column name to count and I also missed a bracket.

Total Open Order Before Today = 
CALCULATE( 
COUNT( Table[Order Number]), 
Table[Status] = "Open", 
Table[Order Date] < TODAY() 
)

[Anonymous]

Hi,

When I was typing, the "Table [Order Number]" was not an option and I had to manually enter it and then recieved the error below.

I did from the rejection, go back and update the Table [Order Number] to  be the actual name of my table and used the ID column as that is the column we use to keep "count".  I didn't recieve an error but the data did not update as it should. Is there somthing I need to clean up in the data soruce?

[parry2k]

@Anonymous yes you need to change column name and table name as per your data model. Since you fixed that, what is the issue? Are you getting wrong result?

I think at this point it will make sense if you can share some sample data using one drive/google drive. Remove any sensitive information before sharing.

[Anonymous]

Hi,

Thank you for your response. I think I am al ltogether trying the wrong command.

Let me re-explain myself: I need to find the rows (ID #s) where the status is open and it is past their deadline. So I am thinkning:

Count Governance [ID] , Governance [Status] = "Open", Governance [Deadline] < Today.

^^ Laymen terms I am trying to ask it to count the ID's where the status is currently open but we are past the deadline date.

[parry2k]

Hey @Anonymous so what is the issue with the expression I sent to you.