Remove Duplicating entries in Matix

[die_kruzen]

Hello All. I have a parent/child relationship I am to display in a matrix. Is there a way to make it so 'This is the title from the parent' just appears once instead of for each child record?

Thank you in advance

REQID		This is the title from the parent
55	22	This is the title from the parent
	34	This is the title from the parent

[die_kruzen]

@Ritaf1983 @amitchandak - thank you both for the info!! I wasn't aware of the ISINSCOPE....until now.

[Ritaf1983]

@die_kruzen 

 Happy to help😊

[Ritaf1983 · Accepted solution]

Hi @die_kruzen 
Yes, you can manipulate what to show by hierarchy level, using the ISINSCOPE function:
for example :

title_ = if(ISINSCOPE('Table'[child]),"",max('Table'[title]))

The result :

pbix is attached

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

[amitchandak]

@die_kruzen , Assume the name of the parent column is parent and child is child , then have a measure like

New measure=

Switch(True(),

isinscope(Table[Child]) , blank(),

isinscope(Table[Parent]) , Max(Table[Text]) ,

Max(Table[Text])

)