Forum Discussion
Remove Duplicating entries in Matix
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 |
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.
4 Replies
- Ritaf1983
Super User
Happy to help😊
- 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])
)
- Ritaf1983
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.
