Forum Discussion

stribor45's avatar
stribor45
Icon for Post Prodigy rankPost Prodigy
2 years ago
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...
Help
  • govindarajan_d's avatar
    govindarajan_d
    2 years ago

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

     

     

     

stribor45's avatar
stribor45
Icon for Post Prodigy rankPost Prodigy
2 years ago

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

govindarajan_d's avatar
govindarajan_d
Icon for Super User rankSuper User
2 years ago

Hi stribor45 ,

 

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

  • stribor45's avatar
    stribor45
    Icon for Post Prodigy rankPost Prodigy
    2 years ago

     

    • govindarajan_d's avatar
      govindarajan_d
      Icon for Super User rankSuper User
      2 years ago

      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's avatar
        stribor45
        Icon for Post Prodigy rankPost Prodigy
        2 years ago

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