Forum Discussion
Sum value with filter and total at the same time
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
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
Use following measure
Total = CALCULATE ( SUM ( yourtable[value] ), ALL( yourtable[month] ) )
2 Replies
- Abduvali
Skilled Sharer
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
vik0810Resolver V
Use following measure
Total = CALCULATE ( SUM ( yourtable[value] ), ALL( yourtable[month] ) )