Issue with cumulative count

[Anonymous]

Hi All, 

I'm encountering a slight issue with my calculation. I have the below table. I need to get a cumulative count where Proposal Type = A, however, i need to ignore the rows where Proposal Date is BLANK. 

When i use the below calculation, it's cumulating on the blank Proposal Date rows as well. Does anyone know how i can just do a cumulative count on the rows where there is an associated Proposal Date value?

Proposal Date	Proposal Type
	A
1/1/21	A
5/1/21	B
	A
	A
10/1/21	A

My measure: 

CALCULATE (

COUNTROWS ( FILTER ( 'ProposalData', 'ProposalDate[ProposalType] = "A") ),

FILTER(ALL('ProposalData'), 'ProposalData'[ProposalDate] <= MAX('ProposalData'[ProposalDate])))

[Vera_33 · Accepted solution]

Hi @Anonymous 

try it

CALCULATE (
COUNTROWS ( FILTER ( 'ProposalData', 'ProposalDate[ProposalType] = "A" && 'ProposalData'[ProposalDate] <> BLANK() ) ),
FILTER(ALL('ProposalData'), 'ProposalData'[ProposalDate] <= MAX('ProposalData'[ProposalDate])))

[Anonymous]

That worked perfectly! Thanks so much!