March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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 |
Solved! Go to Solution.
Hi @die_kruzen
Yes, you can manipulate what to show by hierarchy level, using the ISINSCOPE function:
for example :
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
@Ritaf1983 @amitchandak - thank you both for the info!! I wasn't aware of the ISINSCOPE....until now.
Happy to help😊
Hi @die_kruzen
Yes, you can manipulate what to show by hierarchy level, using the ISINSCOPE function:
for example :
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
@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])
)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
114 | |
76 | |
57 | |
52 | |
44 |
User | Count |
---|---|
165 | |
116 | |
63 | |
57 | |
50 |