Get Row, Col value of RELATEDTABLE in DAX

Question

In DAX I can use RELATEDTABLE to get a table of data I want to refine. I can use FILTER to reduce the table to 1 row that contains the data I actually want.

I can use COUNTROWS to verify that I have 1 row like this:

TEST = COUNTROWS(FILTER(RELATEDTABLE(Config), AND([ConfigColumn1]=="Value1", [ConfigColumn2]==[LocalColumn]))), but how do I actually access the value in a specific column?

How do I get the value of ConfigColumn3 of the first, and only row?

davidebacci · Accepted Answer · 2025-10-24 16:21:30Z

0

Use something like MINX(<your table with a single row>, <column you want>)

answered Oct 24 at 16:21

davidebacci

31.5k4 gold badges20 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Get Row, Col value of RELATEDTABLE in DAX

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related