Sum with filter selected

[Anonymous]

Hi all.

I have 3 cards wiht values.

1 - Values of month selected

2 - Values all Month

3 - I have to calculate the values until month selected.

1 and 2 are ok missing 3

ty.

[v-yuezhe-msft]

@Anonymous,

Could you please share sample data of your table and post expected result in table format?

Regards,
Lydia

[Anonymous]

Look this imagem

https://drive.google.com/file/d/11lCWE0-K-c7J9lAKC9KFnnlq8GAQyhWZ/view?usp=sharing

link for download this example

Ty

[v-yuezhe-msft · Accepted solution]

@Anonymous,

Create measure using DAX below.

Measure = CALCULATE(SUM(Planilha1[values]),FILTER(ALL(Planilha1),Planilha1[month]<MAX(Planilha1[month])))

Regards,
Lydia

[Anonymous]

https://drive.google.com/open?id=1cz81M5SZUrGaN59U6aVHtC779TVtPDUH

Look the Graph "ACUMULADO"

Ty

[Anonymous]

I use this

AllMonths = CALCULATE(SUM(CONTABIL[VALOR])+SUM(CUSTO[VALOR_OBJ]); ALL(MES[Mes]); CUSTO[Flag] = TRUE())+0

SelectMonth = CALCULATE(SUM(CONTABIL[VALOR])+SUM(CUSTO[VALOR_OBJ]); ALLEXCEPT(MES[Mes]); CUSTO[Flag] = TRUE())+0