Error : A table of multiple values was supplied where a single value was expected.

[ssnegi1971]

Getting error "A table of multiple values was supplied where a single value was expected." for the code below. Please advise.

There are no duplicates in the underlying table.

DAX Indexed Table =

    VAR __SourceTable = 'Reports'

    VAR __Count = COUNTROWS(__SourceTable)

    VAR __SortText = CONCATENATEX('Reports',[ReportName],"|",[ReportNo])

    VAR __Table =

        ADDCOLUMNS(

            GENERATESERIES(1,__Count,1),

            "ReportNames1",PATHITEM(__SortText,[Value],TEXT)

        )

    VAR _RTABLE = SELECTCOLUMNS(DISTINCT(__Table),"ReportNames",[ReportNames1])

    RETURN _RTABLE

[bhanu_gautam · Accepted solution]

@ssnegi1971 , Try using

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