Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Measure - Parent child relationship

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...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    7 years ago

    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's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
7 years ago

Both are text.

I changed to number and still the same.

Here  is the pbix

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
7 years ago

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's avatar
    mussaenda
    Icon for Community Champion rankCommunity Champion
    7 years ago

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