Forum Discussion
Variable Equals Selected Value in Slicer
I've been at this for a week now and it's driving me crazy 😅 I have a report that shows various different charts relating to information about cases. Only "Regular Feed" cases should be shown on...
parry2k
Super User
Super UserBlameXen SELECTEDVALUE function will only return value if a single value is selected otherwise it will return blank.
Now to answer your question, could you paste some sample data with the expected output? Make sure to paste your data in raw format as a table, not an image.
Ahh explains the difficulty. Below is an example of the raw data (anonymised):
CaseID CaseType CaseMethod CaseDetails 1 Type1 Method1 Anonymized 2 Type3 Method1 Anonymized 3 Type7 Method1 Anonymized 4 Type1 Method1 Anonymized 5 Type6 Method1 Anonymized 6 Type3 Method1 Anonymized 7 Type1 Method1 Anonymized 8 Type1 Method2 Anonymized 9 Type9 Method1 Anonymized 10 Type3 Method1 Anonymized 11 Type2 Method1 Anonymized 12 Type5 Method1 Anonymized 13 Type2 Method1 Anonymized 14 Type5 Method2 Anonymized 15 Type3 Method2 Anonymized 16 Type1 Method1 Anonymized 17 Type1 Method1 Anonymized 18 Type4 Method1 Anonymized 19 Type5 Method1 Anonymized 20 Type7 Method1 Anonymized
When "Method1" is selected in the filter, I'd like it to look like:CaseID CaseType CaseMethod CaseDetails 1 Type1 Method1 Anonymized 2 Type3 Method1 Anonymized 3 Type7 Method1 Anonymized 4 Type1 Method1 Anonymized 5 Type6 Method1 Anonymized 6 Type3 Method1 Anonymized 7 Type1 Method1 Anonymized 9 Type9 Method1 Anonymized 10 Type3 Method1 Anonymized 11 Type2 Method1 Anonymized 12 Type5 Method1 Anonymized 13 Type2 Method1 Anonymized 16 Type1 Method1 Anonymized 17 Type1 Method1 Anonymized 18 Type4 Method1 Anonymized 19 Type5 Method1 Anonymized 20 Type7 Method1 Anonymized
When "Method2" is selected:CaseID CaseType CaseMethod CaseDetails 8 Type1 Method2 Anonymized 14 Type5 Method2 Anonymized 15 Type3 Method2 Anonymized
But then when "Regular Feed" is selected, only certain types with certain details are shown irregardless of Method (vague I know but it's a pretty sensitive sorting algrothim to our business):CaseID CaseType CaseMethod CaseDetails 3 Type7 Method1 Anonymized 4 Type1 Method1 Anonymized 5 Type6 Method1 Anonymized 6 Type3 Method1 Anonymized 7 Type1 Method1 Anonymized 9 Type9 Method1 Anonymized 10 Type3 Method1 Anonymized 11 Type2 Method1 Anonymized 12 Type5 Method1 Anonymized 15 Type3 Method2 Anonymized 16 Type1 Method1 Anonymized 17 Type1 Method1 Anonymized 18 Type4 Method1 Anonymized 20 Type7 Method1 Anonymized 15 Type3 Method2 Anonymized 16 Type1 Method1 Anonymized 17 Type1 Method1 Anonymized 18 Type4 Method1 Anonymized 19 Type5 Method1 Anonymized 20 Type7 Method1 Anonymized
