topic Look for rows in another table from a dax filtered value in DAX Commands and Tips

Look for rows in another table from a dax filtered value

Anonymous — Fri, 07 Oct 2022 14:22:14 GMT

Hi,

I would like to create a identity card of a machine. This machine has values in different tables.

To display the machine name, i use the following DAX :

Machine name = IF (HASONEVALUE (Table1[Machinename]),SELECTEDVALUE (Table1[MachineName]),"")

I would like to display all the related values of this machine, it works well if these values are in the same table.

How could I look for the certain related in another table?

Thank you in advance for your help.

Re: Look for rows in another table from a dax filtered value

Shaurya — Fri, 07 Oct 2022 16:18:24 GMT

Hi Anonymous,

You can lookup values in another table by using the LOOKUP function.

Please refer to:

https://learn.microsoft.com/en-us/dax/lookupvalue-function-dax

Mark this post as a solution if that works for you!

Re: Look for rows in another table from a dax filtered value

AilleryO — Fri, 07 Oct 2022 16:18:27 GMT

Hi,

We need more information to help you, but at least I can give you some hints that might help.

If both table are linked in Model view you can use RELATED function to get the value from the other table (going from many to one in the relation).

Otherwise you have LOOKUPVALUE function, or merging with Power Query...

In fact many options but depends on your situation.

Let us know

Re: Look for rows in another table from a dax filtered value

Anonymous — Sat, 08 Oct 2022 20:55:13 GMT

Thank you for your replies. Here I add more information

Table1

NAME	GROUP
NAME1	GROUP A
NAME2	GROUP A
NAME3	GROUP A
NAME4	GROUP B
NAME5	GROUP B
NAME6	GROUP B
NAME7	GROUP C
NAME8	GROUP C
NAME9	GROUP C
NAME10	GROUP C
NAME11	GROUP C
NAME12	GROUP C
NAME13	GROUP D
NAME14	GROUP F
NAME15	GROUP F

Table2

SECTION	SUB SECTION	GROUP
SECTION 1	SUB SECTION 11	GROUP A
SECTION 1	SUB SECTION 12	GROUP B
SECTION 1	SUB SECTION 13	GROUP C
SECTION 1	SUB SECTION 14	GROUP D
SECTION 2	SUB SECTION 21	GROUP E
SECTION 2	SUB SECTION 22	GROUP F
SECTION 3	SUB SECTION 31	GROUP H
SECTION 3	SUB SECTION 32	GROUP I
SECTION 3	SUB SECTION 33	GROUP J
SECTION 3	SUB SECTION 34	GROUP K

I would like to display the section and sub section of the selected machine name.

Thank you in advance for your help.

Re: Look for rows in another table from a dax filtered value

Jos_Woolley — Sun, 09 Oct 2022 06:01:19 GMT

Hi,

Something like:

Details Selected Machine Name = VAR SelectedMachineName = [Machine name] RETURN CALCULATE( MIN( Table2[SECTION] ), FILTER( Table1, Table1[Machine name] = SelectedMachineName ) )

Regards