How to show only the child values of a hierarchy

[JL0101]

Hi, I have created a hierarchy (powerbi builtin hierachy creator) and put it into a matrix visual. I only want to show the values of the bottom 2 children of the hierrachy. As it does not make sense to roll up the values to the parent. See screenshots below.

Not this one

only at this level and the one above

I dont want the columns Volume, Count, Quantity, UoM to display quantities at the parent level, these should be blank. However when I drill down to child levels these values should be present. How can this be done ?

[JL0101]

how would I do the same with the color so that it only shows at level4? Not to show at level2 as below only level4. I was using the the condtional background colour but I can't get it to work with isincope function. 

[JL0101]

Perfect

[Anonymous · Accepted solution]

Hi @JL0101 ,

I suggest you to try ISINSCOPE() to achieve your goal.

My Sample:

Measure:

M_Count = IF(ISINSCOPE('Table'[Family&Type]),CALCULATE(SUM('Table'[Count])))

M_Volume = IF(ISINSCOPE('Table'[Family&Type]),CALCULATE(SUM('Table'[Volume])))

Result is as below.

Best Regards,
Rico Zhou

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