Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous 

 

I am not sure how many scenarios you might have, say NOT_AGREED and PARTLY_AGREED will only appear once for each requirement? you need to go through all scenarios...here is one based on your sample only

# of ReqID = 
VAR CurDate=MAX(Dates[Date])
RETURN
IF(SELECTEDVALUE('Tabelle1'[Status])="NOT_AGREED"||SELECTEDVALUE('Tabelle1'[Status])="PARTLY_AGREED",
CALCULATE(COUNTROWS(VALUES(Tabelle1[ReqID])),Tabelle1[ModifiedDate]=CurDate),
CALCULATE(COUNTROWS(VALUES(Tabelle1[ReqID])),Tabelle1[ModifiedDate]<=CurDate))

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Vera,

thanks again for your explanation. Unfortunately I'd like to have this a little bit more dynamic and do not want to explicitly describe every scenario, as you call it.

Can you explain, why my initial approach does not work? Your last solution is only a workaround to make my example work, but of course it would not work with my actual data, because I always need the cumulated data until the date of a line, and not only from that specific date.

So, why is my initial expression returning 2 for PARTLY_AGREED and NOT_AGREED on 3rd and 4th?

Regards,

Marc