cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

Selected Value for Slicer turns totally wrong

hi all , 

i have ptroblem with measure , the result turn right only 1 region , while the others result shown the result of Total Customers instead . I am not sure what's wrong with my measure , all i want is to use the slicer between purchased Outlets and Action. 

Indeed , i have a relationship between my Append 1 table to Master_Data Table :

 

i have mesure with purchased outlets and Action: 

**Purchased Outlets = DISTINCTCOUNT(Append1[Customer Code])
**Total Customers = DISTINCTCOUNT(Master_Data[Customer Code2])
**Action = ABS([Total Customers]-[Purchased Outlets])
 
I wanna create slicer for Purchased Outlets and Action then i create the table as per below : 

2.JPG

I have using below Measure : 
**selection 1 = SELECTEDVALUE(Selection[Type],[Purchased Outlets])
**Type Measure = SWITCH(TRUE(),
Selection[selection 1]="Purchased Outlets",[Purchased Outlets],
Selection[selection 1]="Action",[Action],BLANK())
1.JPG
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Post Prodigy
Post Prodigy

Re: Selected Value for Slicer turns totally wrong

hi all , 

 

i have solve this by disconnecting the relationship between tables ,

while the relationship is made . the result turns out just wrong with the measures i have created. 

 

thanks with Regards, 
Leakna Hang 

View solution in original post

7 REPLIES 7
Highlighted
Solution Sage
Solution Sage

Re: Selected Value for Slicer turns totally wrong

Hi @Chanleakna123 

 

Please provide a sample data and your expected  result.

Thanks.

Highlighted
Super User IV
Super User IV

Re: Selected Value for Slicer turns totally wrong

The information you have provided is not making the problem clear to me. Can you please explain with an example. If possible please share a sample pbix file after removing sensitive information.
Thanks.

My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Highlighted
Post Prodigy
Post Prodigy

Re: Selected Value for Slicer turns totally wrong

hi @mussaenda , @amitchandak 

 

https://www.dropbox.com/s/npijaubmnct2re6/Brand%20Performance.pbix?dl=0

 

above i have shared through dropbox , kindly review and revert back please , 

Highlighted
Super User IV
Super User IV

Re: Selected Value for Slicer turns totally wrong

I am still not sure of the problem to be solved. But I have done some changes.

https://www.dropbox.com/s/sdsyvujbrdmmg5d/Brand%20Performance.pbix?dl=0

 

Also, I feel that you should create a new table from Master_Data and Append using summarize and Join it with Master data and Region. Most of the measures you created in master data should move there.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Highlighted
Post Prodigy
Post Prodigy

Re: Selected Value for Slicer turns totally wrong

HI @amitchandak  , Can you please help me to arrange the data to meet with my purpose ? 
actually , i have no idea now where to start and finish. seems like i have no clue on this now. 
have never met such before. 

Highlighted
Community Support
Community Support

Re: Selected Value for Slicer turns totally wrong

Hi @Chanleakna123 ,

 

I am not sure what desired result would you want, could you please show your desired output screenshots for further analysis?

 

Please read this post to get your answer quickly: How to Get Your Question Answered Quickly.

 

Best Regards,

Amy

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Highlighted
Post Prodigy
Post Prodigy

Re: Selected Value for Slicer turns totally wrong

hi all , 

 

i have solve this by disconnecting the relationship between tables ,

while the relationship is made . the result turns out just wrong with the measures i have created. 

 

thanks with Regards, 
Leakna Hang 

View solution in original post

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors