Forum Discussion
Continued ContributorDate Range Based on User
I found a solution that seems preferable over creating a Dim Dates table that has a User column as this would greatly multiply the size of my Dim Date table (there are many more Users than the two cited above).
I set the cross-filtering direction between the DimDate table and the Fact table to Both instead of Single. I also set the cross-filtering direction to Both between the Dim User table and the Fact table. Now, it works as expected.
I am marking this as the solution, but feel free to comment if there are potential pitfalls to this solution that I am unaware of.
Super User
What you can do is? put in a philtre on your dateslaser where the number. is greater than zero, which will then falter this laser to only show the roads where the user has data. Here is an example
Continued ContributorI found a solution that seems preferable over creating a Dim Dates table that has a User column as this would greatly multiply the size of my Dim Date table (there are many more Users than the two cited above).
I set the cross-filtering direction between the DimDate table and the Fact table to Both instead of Single. I also set the cross-filtering direction to Both between the Dim User table and the Fact table. Now, it works as expected.
I am marking this as the solution, but feel free to comment if there are potential pitfalls to this solution that I am unaware of.