Sum value with filter and total at the same time

[Anonymous]

I have two tables one of valor and another one of the month
I want to select the month by a filter and show the value
total of the selected month I got
now that I want to show the total independent value of selecting the month

If I have column year and selected

select Oct /2017

Look This image

I have to a new box with valor all "Mes"

Unidade = Organization

Ano  = Year

Mes = Month

Real Mes = Real Month

I have to = All Month

Ty

[Abduvali · Accepted solution]

Hi @Anonymous,

Try creating a Calculated measure:

Total = calculate( sum( Sales ), filter( all( 'table name' ), 'table name' [year] = 2017))

This should give you your YTD Total, hope this helps.

Regards

Abduvali

[vik0810 · Accepted solution]

Use following measure

Total = CALCULATE ( SUM ( yourtable[value] ), ALL( yourtable[month] ) )

[Abduvali · Accepted solution]

Hi @Anonymous,

Try creating a Calculated measure:

Total = calculate( sum( Sales ), filter( all( 'table name' ), 'table name' [year] = 2017))

This should give you your YTD Total, hope this helps.

Regards

Abduvali