Codes and Group description codes table

Hi All,
Firstly  Kedar_Pande thank you for your solution!
And LoryMenCR , As I understand it, you want to turn the Group Description column into a hierarchy, right? 
Then we can create a new table, and then use the Path function to give the column a hierarchical relationship and then nested to get the effect you want:

HierarchyTable = 
DATATABLE(
    "Child Description", STRING,
    "Parent Description", STRING,
    "Code", STRING,
    {
        { "Group Description C","Group Description D", 	"576" },
        { "Group Description C","Group Description D", "577" },
        { "Group Description C","Group Description D", "578"},
        
        { "Group Description B", "Group Description C", BLANK() },
        { "Group Description A","Group Description B",  BLANK()},
        { BLANK(),"Group Description A",  BLANK()}
        
    }
)

Path = PATH(HierarchyTable[Parent Description], HierarchyTable[Child Description])

Level1 = PATHITEM(HierarchyTable[Path], 4, TEXT)

Once we have the exact relationship, we can connect our HierarchyTable to Code to form a one-to-many relationship to get the results we need, and finally use a measure to get the right results.

Measure = IF(
    NOT(ISINSCOPE('HierarchyTable'[Code])),
    BLANK(),
    LOOKUPVALUE(Code[Value],'Code'[Code],SELECTEDVALUE('HierarchyTable'[Code])))

If you have further questions, you can check the pbix file I uploaded, I hope my method can help you, I would be honored if I can solve your problem!

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.