Matrix to show values only at the lowest level

[Anonymous]

I have a matrix table that needs to show 3 tiers however the lowest team is where I need the value my measure to show.  I do not want it to roll up totals in the 2 top tiers becuase it is a % and the lowest level doesn't need to be summed up.

Release Name    BE BLANK
        Project Name   BE BLANK
                    Resource Name     BE Measure

Is there a some measure that I can control where the value shows ?   

I tried a the below measure but that only gives me 1 release that only has 1 employee.

MatrixAllocation% =
  IF(
      HASONEFILTER(EmployeeDim[Name]),
      [Allocation%],
      BLANK()
      )

[amitchandak]

@Anonymous , not very sure

MatrixAllocation% =
  IF(
      isfiltered(EmployeeDim[Name]),
      [Allocation%],
      BLANK()
      )

Check if this can help

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

[Anonymous · Accepted solution]

I figured it out - I needed a nested IF.

MatrixAllocation% =
IF(
ISINSCOPE(Release[Release Name with Status]) && ISINSCOPE(CEProject[CE Project Name]),
IF(
ISINSCOPE(EmployeeDim[Name]),
[Allocation%],
BLANK()

),
BLANK()
)

[Anonymous]

Unfortunately, ISFILTERED doesn't change the behavior.  It still shows roll-up sums.