Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Return just one column from DAX table

I have a dax table (code below) wich return two columns (sample below).   DaxTable = var d = date(2022,9,30) var _table = CALCULATETABLE( SUMMARIZE( 'Table', [Project], "Measure", CALCU...
  • MAwwad's avatar
    MAwwad
    3 years ago

    To return just the "Project" column from the table you have defined in your DAX code, you can use the SELECTCOLUMNS function to create a new table that contains only the columns you want to include.

     

    DaxTable = VAR d = DATE(2022,9,30) VAR _table = CALCULATETABLE( SUMMARIZE( 'Table', [Project], "Measure", CALCULATE( COUNT('Table'[key]), 'Table'[status]<>BLANK())- CALCULATE( COUNT('Table'[key]), 'Table'[status]="Fechadas")), 'Table'[date]=d) RETURN SELECTCOLUMNS(_table, "Project", [Project])

MAwwad's avatar
MAwwad
Icon for Solution Sage rankSolution Sage
3 years ago

To return just the "Project" column from the table you have defined in your DAX code, you can use the SELECTCOLUMNS function to create a new table that contains only the columns you want to include.

 

DaxTable = VAR d = DATE(2022,9,30) VAR _table = CALCULATETABLE( SUMMARIZE( 'Table', [Project], "Measure", CALCULATE( COUNT('Table'[key]), 'Table'[status]<>BLANK())- CALCULATE( COUNT('Table'[key]), 'Table'[status]="Fechadas")), 'Table'[date]=d) RETURN SELECTCOLUMNS(_table, "Project", [Project])

ssnegi1971's avatar
ssnegi1971
Frequent Visitor
1 year ago

Hi, I tried to SELECTCOLUMNS to return one column in the table but am getting the error : A Table of multiple values was supplied where a single value was expected"

DAX Indexed Table =
    VAR __SourceTable = 'Reports'
    VAR __Count = COUNTROWS(__SourceTable)
    VAR __SortText = CONCATENATEX('Reports',[ReportName],"|",[ReportNo])
    VAR __Table =
        ADDCOLUMNS(
            GENERATESERIES(1,__Count,1),
            "ReportNames",PATHITEM(__SortText,[Value],TEXT)
        )
    VAR _RTABLE = SELECTCOLUMNS(__Table,"ReportNames",[ReportNames])
RETURN _RTABLE