Forum Discussion
CurrentUser vs SelectedUsers
Anonymous
So I really appreciate your time.
This definitely solves the 1 exact scenario I gave.
Unfortunately, if I add even one additional value to the user slicer, then it breaks.
For instance, if I add User "3-Sarah", then all values for selected users incorrectly go to 0.
Additionally, if no slicer values are selected, then nothing appears in the table visual at all, which is also a problem.
(City slicer should still be filtering the table visual at all times, but it's not anymore now that the slicer is coming from a disconnected table.)
Please keep in mind these slicers are multi-selection.
This is the reason why I have measures which build concatenated lists of the selected values, described in the initial post (as well as in the PBIX).
I also noticed, that you removed the visual cards from the PBIX which display these selected values.
I guess that's fine if we don't display them in a card.
But the solution still needs to be able to see ALL selected values.
NOTE: In the screenshot below, the output of the table visual is incorrect. It should show the data from New York & Los Angeles, because those are the selected cities which should define what appears in the table visual. But also note that I have recreated the cards which hold the selected concatenated lists for each slicer. (multi-selection lists).
Regards,
Nathan
P.S. This solution seems incredibly complex for what I am trying to do.
1) I already have the User ID for each row ("02 Current User ID" shown below).
2) I already have the concatenated list of selected users ("01 Selected Users" shown below).
All I want is 1 more column that checks if #1 exists in #2.
Is it really necessary to create copies of existing tables to do this?
(Forgive my ignorance, but I would think this just needs the creation of 1 more DAX formula that I'm struggling to figure out.)