Need True and False in a Slicer, but nothing is True in data as of yet

[MikeDubya]

Hello, 

I have a need for a slicer that only shows rows that have a flag of true. Unfortunately, my data currently only has data with the false flag.

I have tried a few differnet things, but really no luck. The false data continues to show when right now, nothing should be showing in my table visual. 

The Flag is based off of a Calculated column. If a date is in between a From Date and To Date, it is TRUE, else it is FALSE.

Currently what I see is this:

User ID	Task	Count	Between Dates
1	A	50	FALSE
2	A	43	FALSE
3	B	2	FALSE
4	C	1	FALSE
5	D	700	FALSE

And my slicer looks like this:

Because there are currently no rows that are true, it isn't an option.

What I want to see is this:

User ID	Task	Count	Between Dates

And if a True ever shows up, then this:

User ID	Task	Count	Between Dates
5	Misc	700	TRUE

But since I have nothing with True currently, I can't set up the slicer correctly.

I have tried a T/F Table and a Switch measure that gave me True, like this:

but it didn't work for me.

This is the switch measure: 

TF_SWITCH =

SWITCH(

    SELECTEDVALUE('T/F'[T/F]),

    "True", CALCULATE(MAX('TABLE'[USER_ID]), FILTER('TABLE', [BETWEEN_DATES] <> FALSE())),

    "False", CALCULATE(MAX('TABLE'[USER_ID]), FILTER('TABLE', HLD_MAIN[BETWEEN_DATES] = FALSE()))

)

Admittedly, I may not have that set up correctly. I was/am a bit confused on what the first field in Calculate should be. I figured one of the fields in the table that is being displayed, but maybe I am wrong. 

Any help would be appreciated!

[MikeDubya]

I tried that earlier and it didn't work. That's because I tried joining the wrong table. This was the solution. Thank you!

[AlexisOlson · Accepted solution]

Instead of a switch measure, maybe try creating a relationship from your T/F table to your fact table on the true/false column. Then the T/F slicer should automatically filter 'TABLE'.