Forum Discussion
Solved
Pull the value from returned row
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 l...
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])
Hi stribor45 ,
Can you try like this:
VAR Z = FIRSTNONBLANK(SELECTCOLUMNS(FILTER (Y, [@RANK] = 1),"Country",Y[Country])),[Country])that didnt work for me. The syntax for '.' is incorrect
