Forum Discussion

cpdanielmc21's avatar
cpdanielmc21
Helper I
6 years ago
Solved

Running Total solution for slicer

Hi community I've been trying to apply solutions proposed in this forum for similar issues to mine, but have not been successful so far.   I want to create either a measure or a column that can he...
Need Help
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    Ok.  I played with this some more.  Please try this expression.  Having account in both the table and the slicer makes this a challenge. 

     
    RunningTotal = var thisdate = CALCULATE(MAX(Total[Date]), ALLSELECTED(Total[Account]))
    return CALCULATE(SUM(Total[Amount]), ALLEXCEPT(Total,Total[Account]), Total[Date] <= thisdate)
     

    Regards,

    Pat

mahoneypat's avatar
mahoneypat
Microsoft Employee
6 years ago

Ok.  I played with this some more.  Please try this expression.  Having account in both the table and the slicer makes this a challenge. 

 
RunningTotal = var thisdate = CALCULATE(MAX(Total[Date]), ALLSELECTED(Total[Account]))
return CALCULATE(SUM(Total[Amount]), ALLEXCEPT(Total,Total[Account]), Total[Date] <= thisdate)
 

Regards,

Pat

Tom2001's avatar
Tom2001
Regular Visitor
3 years ago

That is a great measure.

RunningTotal = var thisdate = CALCULATE(MAX(Total[Date]), ALLSELECTED(Total[Account]))
return CALCULATE(SUM(Total[Amount]), ALLEXCEPT(Total,Total[Account]), Total[Date] <= thisdate)

But, I'm facing the situation when I'd need to have all accounts with balances even if they are not in the selection range "From ... To ...."
So, it would be 0 for the Amount but some Running Total that came from all previouse/before the selected dates range periods.
Could this measure be modified to do it?