Apply filter on some rows to not show the rows in Matrix

[Anonymous]

Hi all,

I am looking for a solution to the following problem:

I want the yellow rows to dissapear, because there is no value in "FTE Other Roles". 

The point is, in some cases the row subtotal too has no value in FTE Other Roles (as below). But I want to keep that rows.

So in the image above, I want to keep the yellow rows, but remove the rows which are in the red area.

Can somebody help me with a DAX solution? I've tried to do something with IF statements, but its not good enough. 

Thanks!

[FreemanZ]

hi @Anonymous 

try like:
FTE Contract =
IF(
    [FTE OtherRoles] = BLANK(),
    BLANK(),
    [Your original code for FTE Contract]
)

other measures like FTE Teaching and CheckBlank are similar.

[Anonymous]

Hi @FreemanZ,

Thanks for your quick response! It's almost what I'm looking for. Is there something that can be done to not apply it to the subtotals?

Now all employees with no value in "Other Roles" will dissapear. But I want to keep all employees in, and apply it only to the cell values - in the image below, Council/Committee; DI Hours, Management etc. And not on the row BA-Team 3.

Hope you can help!