Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

DAX Help

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...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
9 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
      Anonymous
      Not applicable
      9 years ago

       

       

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        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.