Forum Discussion

Harry_01's avatar
Harry_01
Regular Visitor
2 years ago
Solved

How to fetch a Column from Directquery Table?

Hi Expert,

I am facing an issue to fetched a column from Directquery Table(Created in Power Query 'Fields Count' ). I am using RELATED function to fetched [ColumnCount] column. But it is not working, and related function is not giving any option to select table and column. Please suggest me a solution for this.

 
Column = RELATED('Fields Count' [ColumnCount])
 
 
 
Thanks You,
Harry
 
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    Harry_01 , RELATED function in DAX is used to fetch a column from a related table in a one-to-many relationship.

    Please checkit once 

     

    if it still does not work you can use LOOKUPVALUE function as alternative

     

    Column = LOOKUPVALUE('Fields Count'[ColumnCount], 'Fields Count'[KeyColumn], 'YourTable'[KeyColumn])

3 Replies

  • bhanu_gautam's avatar
    bhanu_gautam
    Super User
    2 years ago

    Harry_01 , RELATED function in DAX is used to fetch a column from a related table in a one-to-many relationship.

    Please checkit once 

     

    if it still does not work you can use LOOKUPVALUE function as alternative

     

    Column = LOOKUPVALUE('Fields Count'[ColumnCount], 'Fields Count'[KeyColumn], 'YourTable'[KeyColumn])

    • Harry_01's avatar
      Harry_01
      Regular Visitor
      2 years ago

      Hi bhanu_gautam, 

      Thanks for the suggestion. I am trying the LOOKUPVALUE but getting the below error.

       

      A single value for column 'MN ID' in table 'Referance Table' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

       

      When i am using YourTable'[KeyColumn].

      Column = LOOKUPVALUE('Fields Count'[ColumnCount], 'Fields Count'[KeyColumn], 'YourTable'[KeyColumn])

       
  • bhanu_gautam's avatar
    bhanu_gautam
    Super User
    2 years ago

    Harry_01 , RELATED function in DAX is used to fetch a column from a related table in a one-to-many relationship.

    Please checkit once 

     

    if it still does not work you can use LOOKUPVALUE function as alternative

     

    Column = LOOKUPVALUE('Fields Count'[ColumnCount], 'Fields Count'[KeyColumn], 'YourTable'[KeyColumn])