Hope you are all well.
I am trying to figure out the DAX for the following case (also see attached):
Count the Raised but Not Cleared and Verified orders (where the cell has a date as value)
Count the Raised and Cleared but not Verified orders
question on edna forum.pbix (73.8 KB)
Thank you in advance. Appreciate your help.