topic Re: Pull the value from returned row in DAX Commands and Tips

Pull the value from returned row

stribor45 — Mon, 12 Feb 2024 02:35:56 GMT

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"?

Re: Pull the value from returned row

govindarajan_d — Mon, 12 Feb 2024 07:45:38 GMT

Hi stribor45 ,

Can you try like this:

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

Re: Pull the value from returned row

stribor45 — Mon, 12 Feb 2024 13:57:46 GMT

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

Re: Pull the value from returned row

govindarajan_d — Mon, 12 Feb 2024 15:32:41 GMT

Hi stribor45 ,

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

Re: Pull the value from returned row

stribor45 — Mon, 12 Feb 2024 15:41:29 GMT

Re: Pull the value from returned row

stribor45 — Mon, 12 Feb 2024 16:07:06 GMT

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

Re: Pull the value from returned row

govindarajan_d — Mon, 12 Feb 2024 19:46:59 GMT

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?

Re: Pull the value from returned row

stribor45 — Mon, 12 Feb 2024 20:03:36 GMT

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

Re: Pull the value from returned row

govindarajan_d — Wed, 14 Feb 2024 07:35:46 GMT

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])