Forum Discussion

Lohrasp's avatar
Lohrasp
Frequent Visitor
8 years ago

Select a Column From a Calculated Table Inside a Measure

Hello,

 

I understand that I can do what I'm trying to do using the query editor by taking a few steps. However, I'm trying to do this "onthe fly" using one measure. I'm trying to create a table inside a measure, and then select one of the columns from that table:

 

1. Using group by, creates a table, which creates a new column : GROUPBY('Test Table', 'Col 1', "newCol", SUM(Col 2))

2. This produces a table with two columns: 'Col 1', and 'newCol'

3. I would like to select the 'newCol' column, and directly pass it to aggregate functions.

 

I can't seem to find a function in DAX that allows me to simply pick a column from a table, does one exist? For example, if such a function existed and was called SELECT_COLUMN, I would do:

 

SELECT_COLUMN(
    GROUPBY('Test Table', 'Col 1', "newCol", SUM(Col 2)),
    "newCol"

)

 

Thanks in advance for your help.

4 Replies

    • Lohrasp's avatar
      Lohrasp
      Frequent Visitor
      8 years ago

      Hey Greg, thank you very much for taking the time to respond. 

       

      I tried SELECTCOLUMNS and COLUMNSUMMARY, but both seemed to return a table rather than a column. The description of the SELCTCOLUMNS also says "Adds calculated columns to the given table or table expression." 

       

      When I tried to previously pass SELECTEDCOLUMNS to a MIN function, I got an error that only a column can be passed to a MIN. So for example:

       

      MIN( 
          SELECTEDCOLUMNS(Table1, "newCol", [newCol])
      )