Filtering a MAtrix table on sublevel vlaue

Hi, Anonymous 

According to your description, I can understand what you want to achieve, you want to make the rows that Delate is 0 and is in the scope of [ParentAccount] to disappear in the Matrix, right? You can try my steps:

This is my test data based on your Matrix:

I created these two measures:

Delta = SUMX('Table',[P2]-[P1])

Flag =

IF(

    ISINSCOPE('Table'[Parent Account]),

    IF(

        [Delta]=0,0,1),1 )

Then I created a Matrix and place it like this:

As you can see, the row in which Delta is 0 can still appear in the Matrix.

Then I apply a filter to this Matrix, like this:

Then the row disappeared, and you can get what you want.

You can download my test pbix file here

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

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