Measure - Parent child relationship

[Anonymous]

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?

[jdbuchanan71]

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 )
    )

 

[mussaenda]

Strange. I tried your solution, why mine is showing n/a?

[jdbuchanan71]

In your table, is ID a number and Parent ID text?

[mussaenda]

Both are text.

I changed to number and still the same.

Here  is the pbix

[jdbuchanan71 · Accepted 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.

[mussaenda]

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!!