Count with filters after a date

[Anonymous]

I have been trying different ways to get the data I need with no success so hoping someone out here can help me. I'm trying to create a few measures that I can put into a graph. In summary I need to count the number of Projects for each color , step that are after 4/1/2022.  Below is an example table and the exected results table below it.

Proj #	Step Status	Color	Date
363040	Close	Yellow	3/18/22
373914	ETJ	Red	4/29/22
376363	ETJ	Red	5/27/22
373913	ETJ	Yellow	2/5/22
379054	ETJ	Yellow	6/10/22
378473	Close	Red	8/7/22
340188	Close	Yellow	8/14/22
339964	Close	Yellow	6/9/22
352304	ETJ	Red	4/30/22
353587	Close	Red	7/31/22

Expected Results: Row 1 & 4 would not be part of the calculation since they are before 4/1/2022

Color	Step	Count
Red	ETJ	3
Red	Close	2
Yellow	ETJ	1
Yellow	Close	2

Thank you,

dk6569

[parry2k · Accepted solution]

@Anonymous add following measure:

Count = 
CALCULATE ( 
   COUNTROWS ( Table ),
   Table[Date] >= DATE ( 2022,4,1 )
)

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!