DAX Help

[Anonymous]

So I have a matrix that is being generated by this query: -

MTD Consumed data= TOTALMTD([Current Month Consumed data],'Inventory Date'[Date

What I want is the that I want to create a separate measure for each columns (col1, col2 and so on) that gives me the sum of the the column. For example: A measure that gives me sum of col1 that is 1707.76 and second measure that gives 1749.67

[Sean]

How and where (in what context) are you going to use this total - that will determine how to write the Measure.

For instance - you don't have to change anything in the Measure if you display instead of Date - Month on the Rows.

[Anonymous]

@Sean I intend to use this measure and multiply this with another measure to get the final output. So that's why I want to get the numeric output.

[Eric_Zhang]

@Anonymous

What are rows and column in that matrix? Things would be much clear if you could upload a pbix sample file.

[Anonymous]

I have several columns containing numbers in my matrix visualization. Now how do I pull those "Total" (sum) values out for calculation. I need those value to multiply with other measures.

[Anonymous]

@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.

[Anonymous]

I want to extract 1707.76 and so on..all total values ..so that I can multiply them with other measures.

[Anonymous]

@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.

[Sean]

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.