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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Chanleakna123
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

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
amitchandak
Super User
Super User

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...

mussaenda
Super User
Super User

Hi @Chanleakna123 

 

Please provide a sample data and your expected  result.

Thanks.

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 , 

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.

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. 

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.

 

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 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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