When I add a measure, the filter does not work

[ovonel]

I display in a matrix visual in Power BI:

Rows:  

• Client[Parent]
• Client[Name]

Values:

• Fact[Revenue]
• MeasureResp

Code for MeasureResp:

IF (

    ISINSCOPE ( 'Client'[Name] ),

    MAX ( 'Client'[Responsible] ),

    CALCULATE (

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

        FILTER (

            'Client',

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

        )

    )

)

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

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

They filter does not work, it only works if I remove MeasureResp? Why is this?

[lbendlin]

You need to put Client[Client Number] into a variable outside the CALCULATE().  Otherwise your filter only works on row level.