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 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