Count Planned vs Actuals by Date with Pivot Table

With SUMPRODUCT formulas it can be solved easily.
When it must be a pivottable, you must first make the pivottable then make the calculated fields, which can be summarized then

Here is a Power Pivot proposal, which I am hoping someone will be able to improve upon, so that the date will not have to be hard coded into the measures.
1. Produce an Excel table of the data in columns A:J
2. Load the table into the Data Model
3. Add the following measures:
Plan Submission Date_:=CALCULATE(COUNTA([Discipline]),Table1[Plan Submission Date]<=DATE(2022,4,4))
Actual Submission Date_:=CALCULATE(COUNTA([Discipline]),Table1[Actual Submission Date]<=DATE(2022,4,4),NOT(ISBLANK(Table1[Actual Submission Date])))
Plan Approval Date_:=CALCULATE(COUNTA([Discipline]),Table1[Plan Approval Date]<=DATE(2022,4,4),NOT(ISBLANK(Table1[Plan Approval Date])))
Actual Approval Date_:=CALCULATE(COUNTA([Discipline]),Table1[Actual Approval Date]<=DATE(2022,4,4),NOT(ISBLANK(Table1[Actual Approval Date])))
Let us know if you have any questions.

Use Var mDate = MIN(DataDateTable[Data Date])

then replace the hard coded date with mDate

=Var mDate = MIN(DataDateTable[Data Date])
Return CALCULATE(COUNTA([Discipline]),Table1[Plan Submission Date]<=mDate)

Maybe add Slicer for DataDateTable[Data Date] to be able to select date.