filter not working after measure is introduced

[ovonel]

I display in a matrix visual in Power BI:

Rows:  

• Client[Parent]
• Client[Name]

Values:

• Fact[Revenue]

I also have a filter on another Dimension that I use:  Dimension2[Rep]

It works fine with no issues.

Now, I have added the next measure:

IF (

    ISINSCOPE ( 'Client'[Name] ),

    MAX ( 'Client'[Responsible] ),

    CALCULATE (

        FIRSTNONBLANK ( 'Client'[Responsible], 1 ),

        FILTER (

            'Client',

            'Client'[Client Number (Legacy)] = 'Client'[Client Number]

        )

    )

)

(That is, if the matrix is expanded it just returns the responsible for each client, but when it is collapsed, it will find the Responsible where Legacy=Client Number)

After I added this measure in the matrix; the filter on  Dimension2[Representative],stopped working! Why is it?

[Anonymous]

@ovonel 

I can see what you have done, but I was not able to reproduce the issue for investigation. Can you also provide a sample table with the above text description. Thanks.

Paul Zheng