Selected Value for Slicer turns totally wrong

[Chanleakna123]

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 : 

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())

[amitchandak]

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]

Hi @Chanleakna123 

Please provide a sample data and your expected  result.

Thanks.

[Chanleakna123]

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 , 

[amitchandak]

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.

[Chanleakna123]

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. 

[v-xicai]

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.

[Chanleakna123 · 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