Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 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 independent value of selecting the month

 

 

Need Help
Show and Tell
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    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,

     

     

3 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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's avatar
      Anonymous
      Not applicable
      8 years ago

      If I have column year and selected

       

      select Oct /2017 

       

      Show:

       

      Month Valor selected and Total Year Valor

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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