Pull the value from returned row

[stribor45]

Since my table returned is not base table and it is produced using this code

VAR Y  = ADDCOLUMNS ( X, "@RANK", RANKX ( X, [@COUNT],,, DENSE ) )
VAR Z =  FILTER (Y, [@RANK] = 1)

Z table looks like this

Country	@Anonymous	@RANK
Australia	2677	1

How do I get the value "Australia"?

[stribor45]

This code works for me in DAX Studio but when I move it over to my report data doesnt change when I move slicer

DEFINE

VAR SummaryTable =
    SUMMARIZE(
        FILTER('AGENTS TABLE', 'AGENTS TABLE'[Country] <> "Canada"),
        'AGENTS TABLE'[Country],
        "TotalCount", COUNT('AGENTS TABLE'[Call ID])
    )

VAR RankedTable =
    ADDCOLUMNS(
        SummaryTable,
        "Rank",
        RANKX(SummaryTable, [TotalCount], , DESC)
    )

EVALUATE 
    RankedTable

[govindarajan_d]

Hi @stribor45 ,

Can you try like this:

VAR Z = FIRSTNONBLANK(SELECTCOLUMNS(FILTER (Y, [@RANK] = 1),"Country",Y[Country])),[Country])

[stribor45]

that didnt work for me. The syntax for '.' is incorrect

[govindarajan_d]

Hi @stribor45 ,

Can you share a screenshot, after removing any sensitive data?

[stribor45]

[govindarajan_d]

Hi @stribor45,

The formula I gave can be used for a measure, but in terms of EVALUATE it expects a table as a input. 

Can you try the same inside a measure, preferably in Power BI desktop?

[stribor45]

Yes thats why I typed "Evaluate X" instead of Z. I had same error in PBI measure as well

[govindarajan_d · Accepted solution]

Hi @stribor45,

Sorry about that. I had made a typo, where I had put two brackets instead of one. 

Try this: 

FIRSTNONBLANK(SELECTCOLUMNS(FILTER (Y, [@RANK] = 1),"Country",Y[Country]),[Country])