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 need to create a measure to Parent name using id=parentid join.
Table
id | Name | Parent_id |
101 | A | |
102 | B | 101 |
103 | C | 101 |
104 | D | 103 |
105 | E | 103 |
Create a Measure "Parent Name".
id | Name | Parent Name |
101 | A | |
102 | B | A |
103 | C | A |
104 | D | C |
105 | E | C |
Can't modify the Dataset due to company policy.
Is there a way to calculate the measure?
Solved! Go to Solution.
Ahh, I had done mine as a measure. Because you said you couldn't modify the data set I thought you couldn't add a column. I have updated the calculated column to work and also added in the measure in the attached file.
Hello @Anonymous
Give this a try.
Parent Name = VAR RowParent = SELECTEDVALUE ( 'Your Table'[Parent_id] ) RETURN IF ( ISBLANK ( RowParent ), "n/a", LOOKUPVALUE ( 'Your Table'[Name], 'Your Table'[id], RowParent ) )
Strange. I tried your solution, why mine is showing n/a?
In your table, is ID a number and Parent ID text?
oops, I am not the one who posted. I gaveit a try because I want to learn.
And you did not fail me, I really did learn something new from you today.
Thank you @jdbuchanan71 ! You are awesome!!
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |