Forum Discussion
DAX Help
Anonymous You would need to provide an example for a direct response, but I would imagine the solution is using CALCULATE with FILTER to only return certain values you want Summed up.
I want to extract 1707.76 and so on..all total values ..so that I can multiply them with other measures.
Anonymous Do you need something other than
Measure 1 = SUM('tablename'[Col1])
Measure 2 = SUM('tablename'[Col2])
etc, etc?
For instance, are you getting these values because you are filtering the data in some way? If not, the above should work.
That picture could also represent a Matrix with 1 Row field and 1 Column field and 1 Value field.
In which case you'll need to use ALLEXCEPT ( Table, Table[Column] )
However that would also depend on how/where those totals will be used???
EDIT: In fact it could have 2 or more fields in the Columns.
