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 |