Cumulative count

[RossP]

Hi,

I have a cumulative count that is working except when the number is the same the next row, this is my DAX:

cumulative total3 = 
var refArrivals = SUM(Query1[Arrivals])
return
CALCULATE(
    SUM(Query1[Arrivals]),
    FILTER(
        ALLSELECTED(Query1[ReferralSource]),
        CALCULATE(SUM(Query1[Arrivals]) >= refArrivals
        )
    ))

This is the output split by a ReferralSource Row. As you can see it works up until the number is the same and doesnt add it. Any ideas?

Thanks

[amitchandak · Accepted solution]

@RossP , Try like

cumulative total3 =
var refArrivals = SUM(Query1[Arrivals])
return
CALCULATE(
SUM(Query1[Arrivals]),
FILTER(
ALLSELECTED(Query1[ReferralSource]),
Query1[ReferralSource] <= max(Query1[ReferralSource])
)
)

or

cumulative total3 =
var refArrivals = Summarize(Query1, Query1[ReferralSource]), "_sum" SUM(Query1[Arrivals]))
return
sumx(filter( refArrivals, [_sum]< = maxx( refArrivals,[_sum])),[_sum])