Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Total Value Column Measure

Hi guys,   I am trying to create a total values column with the total value (5930) appearing for each row. The total value column i want to make should have 5,930 throughout all the rows but e...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Anonymous,

     

    Please modify that measure like below.

     

    Measure 2 = CALCULATE(SUM('Table1'[Amount]),ALLSELECTED('Table1'))

    Then it will show the sum of amount dynamically based on the filter.

     

     

    Best  Regards,

    Cherry

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous,

 

Please try the measure below.

 

Measure 2 = CALCULATE(SUM('Table1'[Amount]),ALL('Table1'))

Here is an example.

 

 

If you still need help, please share some data sample and your desired output so that we could help further on it.

 

Best  Regards,

Cherry

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    hi v-piga-msft that solvesy issue though wouldnt that create a static non dynamic value. what if i wanted a totals measure like that but with just whatever value is filtered
    • v-piga-msft's avatar
      v-piga-msft
      Resident Rockstar
      7 years ago

      Hi Anonymous,

       

      Please modify that measure like below.

       

      Measure 2 = CALCULATE(SUM('Table1'[Amount]),ALLSELECTED('Table1'))

      Then it will show the sum of amount dynamically based on the filter.

       

       

      Best  Regards,

      Cherry

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago
        Thank you v-piga-msft i couldnt be more happy with the response