Use Table Output from One Measure As the Input of Another

[Antocast]

Hey everyone, I have this measure which results in a single column with X amount of names:

Measure1 =

VAR Names =

CALCULATETABLE(

    SUMMARIZE(Table1,Table1[names]),

    Table2[jobtype]="ABC",

    Table3[RefDate]=max('Calendar'[Dates])

)

RETURN

Names

When I try and use the output [Names] in another Measure with the following code: I get an error:
Measure 2 =

VAR Names = [Names]

RETURN

FILTER(Names,RANKX(Names,Table1[names],,ASC)=1)
""The FILTER function expects a table expression for argument '', but a string or numeric expression was used.""

If I write Measure1 as:

Measure1 =

VAR Names =

CALCULATETABLE(

    SUMMARIZE(Table1,Table1[names]),

    Table2[jobtype]="ABC",

    Table3[RefDate]=max('Calendar'[Dates])

)

RETURN

FILTER(Names,RANKX(Names,Table1[names],,ASC)=1)

I don't get an error and I get the required output
Can someone shed some light as to what I'm doing wrong?

[Anonymous]

Hi @Antocast ,

I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu