Forum Discussion
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 everytime i try to make a measure with such as sum(Values) , it ends up just giving me the value for each row rather than the value for every row.
Can anybody help?
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
8 Replies
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]))
- 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 )
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
- 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
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
