How to fetch a Column from Directquery Table?

[Harry_01]

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

[bhanu_gautam · Accepted solution]

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

[bhanu_gautam]

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

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