Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 :
Solved! Go to Solution.
Hi,
Something like:
Details Selected Machine Name =
VAR SelectedMachineName = [Machine name]
RETURN
CALCULATE(
MIN( Table2[SECTION] ),
FILTER( Table1, Table1[Machine name] = SelectedMachineName )
)
Regards
Hi,
Something like:
Details Selected Machine Name =
VAR SelectedMachineName = [Machine name]
RETURN
CALCULATE(
MIN( Table2[SECTION] ),
FILTER( Table1, Table1[Machine name] = SelectedMachineName )
)
Regards
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.
Tg
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
Hi @vnqt,
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |