Forum Discussion
Issue with cumulative count
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])))