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

AlB's avatar
AlB
Community Champion
7 years ago

Hi Anonymous

I'm afraid you provide too little info for a clear answer.

To get rid of the filter from the rows, try   SUM(ALL(YourTableName[Values]))

Anonymous's avatar
Anonymous
Not applicable
7 years ago
hi @AIB there isnt much context as i only want to be able to learn how to create a sum everything in a particular range defined by whatever is filtered or not. I saw this done in the definitive guide to dax though the way they did it seems to not yield the same results for me ( they just used a simple sum function and it seemed to ignore the row to row context of dax though i am not sure how )