Specify outcome based on slicer selection

[Anonymous]

Hi, 

Please bear with me while I try to explain the issue as best as possible!

I have three levels of filters. Slicers are made in this order 1. Country 2. Investment target 3. Description. 

What happens: When I select Country A, all the corresponsding information appears (all other Description rows of Country A)

What I'm seeking: When I select Country A, I want a specific description to appear (which is applicable to all other investments), but it is being duplicated. 

So I just tell powerbi, if I select country A, show me description X, and when I select the Investment Target, show me description X + Y. Intstead of selecting Country A and getting description X and Y (while only X is relevant).

I hope this made sense to you. Appreciate your help!!

[v-diye-msft]

Hi @Anonymous 

You might consider providing your dummy pbix that would be helpful for us to investigate it further. 

You can upload it to the onedrive for business and share the link here. please don't forget to disclose the expected results and remove the confidential info.

[amitchandak]

@Anonymous , Based on the description, I think you want to control the values of two unrelated slicers. For that you have use  measure from fact and check is nonblank

refer steps :

https://www.youtube.com/watch?v=cyOquvfhzNM

[Anonymous]

I'm not looking for a filter of a second level slicer. The second level slicers should be the same. I want the table showing the description to show a certain value upon selection of "Country ".

[amitchandak]

@Anonymous Can you share some kind screenshot or expected output