topic Return just one column from DAX table in DAX Commands and Tips

Return just one column from DAX table

Anonymous — Tue, 20 Dec 2022 10:33:48 GMT

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", CALCULATE( COUNT('Table'[key]), 'Table'[status]<>BLANK())- CALCULATE( COUNT('Table'[key]), 'Table'[status]="Fechadas")), 'Table'[date]=d) RETURN FILTER(_table,[Measure]>0)

Project	x
A	1
B	3
C	3
D	1
E	1

I need to calculate the same approach and to return just the 'Project' column

Project

How can I solve this?

Thank you 😄

Re: Return just one column from DAX table

MAwwad — Tue, 20 Dec 2022 11:27:03 GMT

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])

Re: Return just one column from DAX table

Anonymous — Tue, 20 Dec 2022 14:09:49 GMT

It's working 😄 Thank you!

Re: Return just one column from DAX table

ssnegi1971 — Sat, 19 Apr 2025 23:07:30 GMT

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