Forum Discussion
New Column with Total Value Sum
Hello,
I am trying to create a new column with every row equal to the total sum of a different row. However, when I sum the column my new column sums the each row, rather than having the same number for each row.
I am trying to have every row have the number 2603
Not sure why you would want to do that but you can add a filter modifier like "ALLSELECTED()" to your measure.
2 Replies
- lbendlin
Super User
Not sure why you would want to do that but you can add a filter modifier like "ALLSELECTED()" to your measure.
Hi Anonymous ,
Please try below steps:
1. below is my test table
Table:
2. create a new column with below dax formula
Column = SUMX ( ALL ( 'Table' ), [Total value] )Please refer the attached .pbix file.
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.