Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ovonel
Post Prodigy
Post Prodigy

filter not working after measure is introduced

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?

1 REPLY 1
V-pazhen-msft
Community Support
Community Support

@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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors