Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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.
Solved! Go to 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])
Proud to be a Super User! |
|
@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])
Proud to be a Super User! |
|
@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])
Proud to be a Super User! |
|
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])
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
84 | |
76 | |
75 | |
43 | |
36 |
User | Count |
---|---|
109 | |
56 | |
52 | |
48 | |
43 |