I have 2 tables: the larger table (L) is of the aggregate data and the smaller table (S) has more specific data. S has columns for date, user, and the number of times the user failed to log in, as S shows the the user with the largest number of failed logins for each day. With that said, there will never be a repeated day in table S. L contains data for all the logins for each day. I am creating a report that draws multiple graphs from the aggregate data (L) and want to be able to slice that data via a date slicer (which I am able to do). I also want to create cards which shows the information of S and want L's date slicer to be able to filter that out since both L and S have the same dates. However, when I try to create a relationship between the 2 tables, L's date slicer always results in (Blank) in S's cards. I've tried creating a Date table, but that also doesn't give the result I want (the cards still become (Blank) and the date table slicer has too many dates. I only want the specific dates that show up in the aggregate table).
Small Table Example:
Date User FailedLogins
2018-06-10 Mary 3
2018-06-11 John 2
2018-06-13 Frank 4
Large Table Example:
Date User OtherData
2018-06-10 Mary …
2018-06-10 Mary …
2018-06-10 Mary …
2018-06-10 John …
2018-06-10 Frank …
2018-06-11 John …
2018-06-11 John …
2018-06-11 Frank …
2018-06-13 Frank …
2018-06-13 Frank …
2018-06-13 Frank …
2018-06-13 Frank …
