Forum Discussion

die_kruzen's avatar
die_kruzen
Frequent Visitor
2 years ago
Solved

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?   Tha...
  • Ritaf1983's avatar
    2 years ago

    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.