Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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 independen...
Need Help
Show and Tell
  • Abduvali's avatar
    Abduvali
    8 years ago

    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's avatar
    vik0810
    8 years ago

    Use following measure

     

    Total = CALCULATE ( SUM ( yourtable[value] ), ALL( yourtable[month] ) )
vik0810's avatar
vik0810
Icon for Resolver V rankResolver V
8 years ago

Use following measure

 

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