calculating running total of stores opened by specific date

[Jay2022]

So I want to calculate a running total to use in a visual (perhaps creating a new measure etc) i want to count how many stores have opened by any specific date. My data is like so.

01/12/2019 - Store A

16/12/2019 Store B

01/06/22 Store C

06/04/23 Store D

and so on. 

I saw a tutorial explaining it regards to sales but i can't seem to amend the calculation to show what I want. 

Any help greatly appreciated. 

[DOLEARY85 · Accepted solution]

Hi,

you could try creating a calculated column with something like this:

Running Total =

    CALCULATE (

        Count ('Table'[Store]),

        ALL ('Table'),

       'Table'[Date] <= EARLIER ('Table'[Date]))

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Jay2022]

your measure ignores blanks anyway though i'd still be interested what to add to the calculate column, very helpfull overall thank you 

[Jay2022]

The Calculated column works great thank you so much only one thing how do i get it to exclude the blanks in the calculation please ?

[DOLEARY85 · Accepted solution]

Additionally if you'd prefer a measure the below could work:

Running Total (m) =

    CALCULATE (

        Count  ('Table'[Store]),

        FILTER (

        ALL ('Table'),

        'Table'[Date] <= MAX ('Table'[Date])))

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[DOLEARY85 · Accepted solution]

Hi,

you could try creating a calculated column with something like this:

Running Total =

    CALCULATE (

        Count ('Table'[Store]),

        ALL ('Table'),

       'Table'[Date] <= EARLIER ('Table'[Date]))

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍