Total Value Column Measure

[Kote101]

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?

[v-piga-msft]

Hi @Kote101,

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

[Kote101]

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 · Accepted solution]

Hi @Kote101,

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

[Kote101]

Thank you @v-piga-msft i couldnt be more happy with the response

[AlB]

Hi @Kote101

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

[Kote101]

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 )