Forum Discussion
DAX Help
Community ChampionHow 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.
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.
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 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.
Eric_ZhangMicrosoft Employee
Anonymous
What are rows and column in that matrix? Things would be much clear if you could upload a pbix sample file.