Show value from selected slicer with multiple slicers from same table

[Charles-CW]

Good day all,

I need some advise please.

I have a custom table as seen below which I want to use for slicers.

The challenge I am having is retrieving only the selected value from the individual slicers. I have disabled the interaction between the slicers so that they would not affect each other but I am not able to retrieve the value on the individual selected slicer.

If all my values from all the slicers are the same then I am returning the value based on the DAX measure but as soon as I select different values then I get Blank() results. 

I fully understand why I am getting these blank() results and I am hoping there is a measure that I can use to only display the value of the current slicer as seen in the "Slicer x Desired Value" in the images below i.e.: break it up like disabling the interaction between the slicers.

Custom Table

Results if all slicers are on the same value - based on the dax measure

Results when different slicer values are selected - Also note that the interaction between the slicers are disabled

Slicer 1 Value measure tried but not working

Slicer 2 Value measure tried but not working 

Slicer 3 Value measure tried but not working - Not getting a blank but not getting the correct result either.

Slicer 4 Value measure tried but not working 

Slicer 5 Value measure tried but not working

Desried values - This is where I am stuck 😞

I am sure and hope it might be something simple where I would not have to create 5 different slicer tables.

[Greg_Deckler]

@Charles-CW I went ahead and mocked this up. It's definitely an autoexist issue. Even unpivoting doesn't help because of autoexist. You need 5 disconnected slicer tables. The upside is that you don't need to worry about edit interactions. See attached PBIX below signature.

[Charles-CW]

@Greg_Deckler, thank you.

I was hoping to get away from the 5 additional tables.

On the plus side I now don't feel to bad for not being able to get this to work.

[Greg_Deckler]

@Charles-CW Once you hit an autoexist issue, it's all over. Wish they would allow you to toggle that off...

[Greg_Deckler]

@Charles-CW Can you post an example file or data as text? I am concerned that this is an AutoExist issue and if that is indeed the case, then the only answer might be to unpivot your rows perhaps.

[Charles-CW]

@Greg_Deckler, thank you for the feedback.

Please see herewith a link to the pbix file: PBIX