Filter a week of the year and sum the values of that week plus the values of all other weeks before.

[Anonymous]

Hello everyone,

I have a dashboard based on weeks of the year, and I need to count the products based on the week they are approved.

For example, on week 15 have 15 itens aproved, on week 16 have 3 products approved, on the week 22 I have approved other 2 itens, and so on. The column chart it's alright, it shows the information like this: week 1=0 Porducts, week 2=0 Porducts, (......), week 15=15 products, week 16=18 Products, week 17=18 Products,  week 18=18 Products,  week 19=18 Products,  week 20=20 Products.

But my KPI card it's not right, because when I select for example the week 20, it filter only the values of this week and not make the sum of all other weeks before. How can I filter on the slicer the week selected plus all the weeks before?

[FrankAT · Accepted solution]

Hi @Anonymous 

you can do it like this:

Sum WTD = 
CALCULATE(
    SUM('Table'[Items]),
    FILTER(
        ALL('Table'),
        'Table'[Week] <= SELECTEDVALUE('Table'[Week])
    )
)

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[Anonymous]

Hi Frank!

Thank's a lot. It work perfectly.