cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Getting on slicer to filter another with a measure

Hi there, 

I have one column and one measure that sit in the same table. 

Slicer 1 - Manager

Sliver 2 - FullName (Measure) 

 

The columns in the measure come from the same table. 

 

When i choose Manager -> Dave , then the full names appear under Dave thats fine - i then choose one. 

I then go and change the manager but the full name i chosen last time is in the list along with the other full names from the manager i have chosen. 

 

As all the data comes from the same table - I dont think it is the bi-directional in the dataset. Any ideas how i can stop this from happening ? 

 

I want the manager to have the correct full names and not the previous selected info. 

 

Jason 

 

2 REPLIES 2
v-xiaoyan-msft
Community Support
Community Support

Hi@Anonymous, 

 

Have your problems been solved now? I cannot really follow your mind.

If not ,sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490


Hope it helps.

 

Best Regards,

Caitlyn Yan

amitchandak
Super User
Super User

@Anonymous , how you have created the measure?

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors