Forum Discussion
FILTER ALL Syntax Troubles
MFelix , I am trying a different tack to solve a problem that has been vexing me for a while. Right now, I have a dynamic visual that changes two tables in the exact same way. Im trying to figure out how exactly the filter context works to see if I can use the same dynamic visual to produce multiple distinct tables.
Video of fields changing as I click on dates.
I have the same fields populating the tables. 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.
Here is a link to the data I used.
I have attached pictures of everything else below here. If there is anything else you might need from me, please, let me know. Im driving myself crazy trying to figure this out. Im sure its going to be simple, too.
Thanks!
This is my data modelThis is the custom visual that I am using
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.