Access the nth value of a table

[Syndicate_Admin]

Hello forum,

I'm looking for a possible solution for the following problem. I need to access the umpteenth column of the table generated from the TOPN function. I read in the Power BI documentation about the LASTNONBLANK function, however in its implementation it does not work with the generated table. Any solution?

Below I share the code generated for the particular measure
Clarifications
The total_streams column contains the plays of each of the songs in the dataset. The information is obtained from the intersection of the Song, Streams, Artist and Calendar tables.

Second Most Popular Artist =

WERE Streams_Artista =

SUMMARIZE(

'Song - Streams - Artist - Calendar',

'Song - Streams - Artist - Calendar'[nombre_artista], "Streams Totales", SUM('Song - Streams - Artist - Calendar'[total_streams])

)

WERE Top_2 = TOPN(2, Streams_Artista, [Streams Totales], DESC)

WERE Segundo_Artista = (this variable should store the name of the artist who is in the second place at the top)

RETURN

Segundo_Artista

[Legend_11 · Accepted solution]

Segundo_Artista =
VAR Streams_Artista =
SUMMARIZE(
'Song - Streams - Artist - Calendar',
'Song - Streams - Artist - Calendar'[nombre_artista],
"Streams Totales", SUM('Song - Streams - Artist - Calendar'[total_streams])
)
VAR Top_2 =
TOPN(2, Streams_Artista, [Streams Totales], DESC)
VAR Second_Artist_Table =
TOPN(1, TOPN(2, Streams_Artista, [Streams Totales], DESC), [Streams Totales], ASC)
VAR Segundo_Artista =
SELECTCOLUMNS(Second_Artist_Table, "nombre_artista", 'Song - Streams - Artist - Calendar'[nombre_artista])
RETURN
CONCATENATEX(Segundo_Artista, [nombre_artista], ", ")