rangesum above return null/0 when select dimension

[fsilva1]

Hi guys,

I have a measure that I'm using rangesum, above, and the result is ok. But when I select one dimension in my pivot table the return is 0.

I have dimension, period, city and the column as category

If I filter the first dimension Period, the result of line that I had select is 0

my expression:

rangesum(below(sum({<period_2-={'$(=min(period_2))'}>}[value]),0,RowNo())) 

I trid to ignore selction, but the result is different

rangesum(below(sum({<period_2-={'$(=min(period_2))'},period,period_2,city,category>}[value]),0,RowNo())) 

[vinieme12]

Try as below

=Rangesum(
AGGR({<period,period_2,city,category>}
below(sum({<period_2-={'$(=min(period_2))'}>}[value]),0,RowNo())
,period,period_2,city,category) 
 ) 

[fsilva1]

thanks for your answer...

Now, when I select i can see the value that I selected, this is good, but I think this happen because Include {1} in the min period

The problem now is, that is not accumulating more.

I remove all dimension, to test I'm working just with period.

I dont know, how to do cumulative and dont show 0 when select value

Rangesum(
Aggr({<period>}
BELOW(sum({< period-={'$(=min({1}period))'}>} [value])
,0,
RowNo())
,period)
)
selecting, with your suggestion:

without selecting: Is not accumulating more

Removing the aggr, now is cumulative, but when I select the value to 01/02/2022 is not acumulative

Rangesum(
//Aggr({<period>}
BELOW(sum({< period-={'$(=min({1}period))'}>} [value])
,0,
RowNo())
//,period)
)