HIERARCHY

[dfs29]

Hello , 

I would like to display matrix on power bi with parent and children. 

But when I filter on ParentPath the display is only the children : 

However when I add ParentPath on matrix the result is wrong : 

But I would like this display :

We can see parentPath ( .HRS.HRS02.Q) on the same table of children (.HRS.HRS02.Q.CEXP / .HRS.HRS02.Q.HorsCEXP)

[v-zhangti · Accepted solution]

Hi, @dfs29 

You can try the following methods.
Table:

Slicer = VALUES('Table'[Activite])

Measure:

Measure = FIND(SELECTEDVALUE(Slicer[Activite]),MAX('Table'[Activite]),1,0)

Result:

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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