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
  • v-sihou-msft's avatar
    v-sihou-msft
    8 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,

     

     

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 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

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