Power BI - Cumulative Sum over Time using Parameter Inputs Only

[Anonymous]

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 tasks will be completed over time? If I change the number of tasks to 20 a day how does this cumulative sum change?

My calculation so far are:

Task Parameter = GENERATESERIES(10, 30, 1)

Task Parameter Value = SELECTEDVALUE('Task Parameter'[Task Parameter], 10)

I also have a Date table, with start date of 01/08/2023. 

So the output - likely a measure due to the dynamic nature of parameters - to visualise would be:

01/08/2023 10

02/08/2023 20

03/08/2023 30

...

How can I create this measure seeing as the parameter and date do not have a clear link?

Thanks in advance.

[parry2k]

@Anonymous good to know. Awesome 👏

[parry2k · Accepted solution]

@Anonymous try somethign like this:

Measure = 
CALCULATE ( 
    COUNTROWS ( 'Calendar' ), 
    FILTER ( 
        ALLSELECTED ( 'Calendar'[Date] ), 
        'Calendar'[Date] <= MAX ( 'Calendar'[Date] ) 
    ) 
) * [Task Parameter Value]

[Anonymous]

Works perfectly, thank you @parry2k