How to include rows with date null using a date range slicer

[sandraCortes]

Hello Everyone,

I have an issue that I don't know how to handle, someone can help me?

In a report we have a slicer for a date range and a table that retrieves data according to that filter and other slicers. However the user wants to include in addition to the rows that correspond to the date range, all rows that have a null date.

I added to the fact table query all the rows with null date and I can show them in the table, however when  the user applies the date range filter these ones dissapear from the table. This is because of this relationship:

I appreciate your ideas. 

[ryan_mayu · Accepted solution]

@sandraCortes 

try to delete the relationship between two tables and create a measure

Measure = if(ISBLANK(max('Table'[date])),1,if(max('Table'[date])<min('Table 2'[date])||max('Table'[date])>max('Table 2'[date]),0,1))

add the measure to the visual filter and set the value to 1

pls see the attachment below