Forum Discussion
FILTER ALL Syntax Troubles
Hi CEllinger ,
Can you give me a little bit more information about the result you want to achieve please.
When you refer "When I click a date, I want one table to show the responses filtered by visual and other table to show the table I was describing in my OP" whatis exactly the final result you want to achieve?
Based on the tables you submitted can you share a mockup of the result?
Sorry for the late response.
Regards,
MFelix
MFelix , dont apologize for a late response. I appreciate the help regardless of the timeline!
So, to give you the entire picture:
I have a Calendar Slicer Visual that whose measure is
Approved Request = CALCULATE(DISTINCTCOUNT('Full Time Off'[Emp_ID]),'Full Time Off'[Approved]=8)The Calendar Slicer Visual shows a count of Employees that are off on a selected day.
Date OffEmployee
| 4/2/2019 | Idalia Woolston |
| 4/2/2019 | Sofia Sevy |
| 4/3/2019 | Idalia Woolston |
| 4/3/2019 | Sofia Sevy |
| 4/4/2019 | Idalia Woolston |
| 4/4/2019 | Sofia Sevy |
| 4/4/2019 | Ray Medders |
| 4/5/2019 | Idalia Woolston |
I want to see all of the Employees that will be off on a selected date. If I drop my Employee's Names into a table (Table 1) on my report, selecting a single day will list all of those Employees counted by the Measure.
e.g. If I click on 4/4/2019, I get
| Idalia Woolston |
| Sofia Sevy |
| Ray Medders |
I want to be able to create a table (Table 2) with the exact same data but that shows all of those Employees NOT identified by the initial measure.
Original Employees Table 1 Table 2
| Selene Styons | Idalia Woolston | Selene Styons |
| Idalia Woolston | Sofia Sevy | Wynona Mailhot |
| Wynona Mailhot | Ray Medders | Leana Fleeman |
| Leana Fleeman | Nathanael Hough | |
| Nathanael Hough | Nereida Cardamone | |
| Sofia Sevy | Nickolas Linquist | |
| Nereida Cardamone | Danae Pon | |
| Nickolas Linquist | Mervin Mcgilvray | |
| Danae Pon | Jessenia Trapp | |
| Mervin Mcgilvray | Hilton Soule | |
| Ray Medders | Alesha Griffeth | |
| Jessenia Trapp | Emil Rachel | |
| Hilton Soule | Beatriz Kessinger | |
| Alesha Griffeth | Agnes Gum | |
| Emil Rachel | Clarita Rockmore | |
| Beatriz Kessinger | Leslee Lengyel | |
| Agnes Gum | Mac Napper | |
| Clarita Rockmore | ||
| Leslee Lengyel | ||
| Mac Napper |
Does that make more sense? Also, thank you so much for all of your time already.