Forum Discussion
Cumulative count split by attribute's values
Hello community, I have been trying to find a solution to the following problem. This is the scenario: Projekt ReqID Status ModifiedDate C 12345 AGREED 02.07.2022 00:00:00 C 112233 ...
Hi Anonymous
Should be the ALLSELECTED, you can do like this
# of ReqID =
CALCULATE(COUNTROWS(VALUES(Tabelle1[ReqID])), Tabelle1[ModifiedDate]<=MAX(Tabelle1[ModifiedDate]))
Thanks a lot for your answer, Vera.
There is still something missing though: now the sums in lines don't add up. For 3rd and 4th, there should be a 1 for AGREED, too.
(Sorry, I can't get the formatting nice on my "expected results" table.)