cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jason_Hough
New Member

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-caitlyn-mstf
Community Support
Community Support

Hi@Jason_Hough, 

 

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

@Jason_Hough , 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.



Learn Power BI - Full Course with Dec-2022, with new DAX functions like Window, Index, Offset !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Formatted Profit and Loss Statement with empty lines

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.