Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Power BI - Cumulative Sum over Time using Parameter Inputs Only

Hi I am trying to draw a line on my Power BI visual that shows the inputs of a parameter, and the cumulate/sum of these results over time. The example is; if I complete 10 tasks a day, how many task...
Need Help
  • parry2k's avatar
    parry2k
    3 years ago

    Anonymous try somethign like this:

     

    Measure = 
CALCULATE ( 
    COUNTROWS ( 'Calendar' ), 
    FILTER ( 
        ALLSELECTED ( 'Calendar'[Date] ), 
        'Calendar'[Date] <= MAX ( 'Calendar'[Date] ) 
    ) 
) * [Task Parameter Value]
parry2k's avatar
parry2k
Super User
3 years ago

Anonymous try somethign like this:

 

Measure = 
CALCULATE ( 
    COUNTROWS ( 'Calendar' ), 
    FILTER ( 
        ALLSELECTED ( 'Calendar'[Date] ), 
        'Calendar'[Date] <= MAX ( 'Calendar'[Date] ) 
    ) 
) * [Task Parameter Value]
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Works perfectly, thank you parry2k