Accumulated values with two columns

[Anonymous]

hi 

i am trying to create an accumulation of the delta open CR - that also should be filtered according to the selected filtering 

the Acc Open CRs is accumulationg ALL open CRs in the system and not by selected month

Acc Open CRs = CALCULATE([Number of open CRs];FILTER(ALL('cr');'CR'[Date]<=MAX('CR'[Date]))) 

[v-sihou-msft · Accepted solution]

@Anonymous

Just change ALL into ALLSELECTED in your FILTER. 

Acc Open CRs = CALCULATE([Number of open CRs];FILTER(ALLSELECTED('cr');'CR'[Date]<=MAX('CR'[Date]))) 

See my sample below:

Regards,

[Anonymous]

great thanks, so simple and logical that it seemed difficult 🙂