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

[v-sihou-msft · Accepted solution]

@Anonymous

You just need to create two measures like: 

Total =
CALCULATE ( SUM ( varlor[value] ), ALL ( 'valor' ) )

Total of selected =
CALCULATE ( SUM ( varlor[value] ), ALLSELECTED ( 'valor' ) )

Regards,

[Anonymous]

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

[Anonymous]

If I have column year and selected

select Oct /2017 

Show:

Month Valor selected and Total Year Valor