Get value from a table column - concisely

[vfx661]

I'm coming from R where for a table called 'tbl' we can get a value like this:
tbl[i, j]

or if the table only has one row
tbl[j]

Is there something similar in DAX? 

I've been using 

FIRSTNONBLANK(tbl[j], 1) 
and this gets unreadable fast since I'm using a lot of values from the table.

Please note - there are some differences if j is a number, string or variable name - in this case please assume j is a string value.

##  Updated 30 July 2024 ##

Please find example attached.  In the example (sorry it seems no option to attach a PBIX), the user selects a country and the country and capital are shown as a crumb on the right side.  The measure DAX is also shown in a text box bottom left, and a preferred DAX (which doesn't work but indicates my intent) is on the right.

I'm flexible with the syntax, the main problem with the working approach besides the verbosity is that I have to get the FIRSTNONBLANK value twice, and if it is a big table, then this is not as performant as being able to get a single row and then take the values from that row.  

[vfx661]

I can't see an option to share a PBIX... image, video is there, but not option to share a file.
 

[Ritaf1983]

@vfx661  Save it in some cloud drive and share via link

[Ritaf1983]

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly