Forum Discussion

RossP's avatar
RossP
Advocate I
4 years ago
Solved

Cumulative count

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

 


 

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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])

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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])